/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * TambahPegawai.java
 *
 * Created on Jun 19, 2013, 11:38:46 AM
 */
package View;

import Controller.ControlData;
import Model.AnggotaKeluarga;
import Model.Instansi;
import Model.KK;
import Model.Operator;
import Model.PNS;
import Model.SK_CPNS;
import Model.SK_Karpeg;
import Model.SK_PangkatTerakhir;
import Model.SPTKG_Terakhir;
import Model.S_Nikah;
import TableModel.TampilAnggotaKeluarga;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;

/**
 *
 * @author a9uszT
 */
public class EditPegawai extends javax.swing.JFrame {

    PNS pegawai = new PNS("-", "-", "-", "-", "-", "-", "-", "-", "-", "-", "-");
    AnggotaKeluarga ak;
    String idSuratkk;
    String NIP;

    /**
     * Creates new form TambahPegawai
     */
    public EditPegawai() {
        initComponents();
        KK_Internal.setVisible(false);
        KK_TambahAnggota_button.setEnabled(false);
        AK_Pekerjaan_TF.setEditable(false);
        Clock clock = new Clock();
        clock.showDigitalClock(time);
    }

    public EditPegawai(String nipBaru) throws Exception {
        initComponents();
        KK_Internal.setVisible(false);
        KK_TambahAnggota_button.setEnabled(false);
        AK_Pekerjaan_TF.setEditable(false);
        Clock clock = new Clock();
        clock.showDigitalClock(time);

        isiCPNS(nipBaru);
        isiSK_PangkatTerakhir(nipBaru);
        isiSPTKG_Terakhir(nipBaru);
        isiSK_Karpeg(nipBaru);
        isiS_Nikah(nipBaru);
        isiKK(nipBaru);
        isiTempatInstansi(nipBaru);
        NIP = nipBaru;
    }

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        KK_Internal = new javax.swing.JInternalFrame();
        jPanel4 = new javax.swing.JPanel();
        jLabel9 = new javax.swing.JLabel();
        jPanel5 = new javax.swing.JPanel();
        jLabel18 = new javax.swing.JLabel();
        jLabel25 = new javax.swing.JLabel();
        jLabel26 = new javax.swing.JLabel();
        jLabel29 = new javax.swing.JLabel();
        jLabel30 = new javax.swing.JLabel();
        jLabel37 = new javax.swing.JLabel();
        jLabel38 = new javax.swing.JLabel();
        jLabel50 = new javax.swing.JLabel();
        jLabel87 = new javax.swing.JLabel();
        jLabel88 = new javax.swing.JLabel();
        jLabel89 = new javax.swing.JLabel();
        jLabel90 = new javax.swing.JLabel();
        jLabel91 = new javax.swing.JLabel();
        jLabel92 = new javax.swing.JLabel();
        AK_Batal_button = new javax.swing.JButton();
        AK_Simpan_button = new javax.swing.JButton();
        AK_Nama_TF = new javax.swing.JTextField();
        AK_NIK_TF = new javax.swing.JTextField();
        AK_TempatLahir_TF = new javax.swing.JTextField();
        AK_JK_Combo = new javax.swing.JComboBox();
        AK_TanggalLahir_Date = new com.toedter.calendar.JDateChooser();
        AK_NoPaspor_TF = new javax.swing.JTextField();
        AK_NamaAyah_TF = new javax.swing.JTextField();
        AK_NamaIbu_TF = new javax.swing.JTextField();
        AK_Agama_Combo = new javax.swing.JComboBox();
        AK_Pendidikan_Combo = new javax.swing.JComboBox();
        AK_Pekerjaan_Combo = new javax.swing.JComboBox();
        AK_StatusKawin_Combo = new javax.swing.JComboBox();
        AK_HubKeluarga_Combo = new javax.swing.JComboBox();
        AK_Kewarganegaraan_Combo = new javax.swing.JComboBox();
        AK_Pekerjaan_TF = new javax.swing.JTextField();
        AK_NoKitasKitap_TF = new javax.swing.JTextField();
        jLabel93 = new javax.swing.JLabel();
        jLabel107 = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jPanel2 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jPanel3 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        Tab_PNS = new javax.swing.JTabbedPane();
        SK_CPNS = new javax.swing.JPanel();
        CPNS_update_button = new javax.swing.JButton();
        jLabel3 = new javax.swing.JLabel();
        CPNS_TmpBuatSurat_TF = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        CPNS_NoSurat_TF = new javax.swing.JTextField();
        CPNS_nama_TF = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        CPNS_TmpLhr_TF = new javax.swing.JTextField();
        jLabel7 = new javax.swing.JLabel();
        CPNS_TglSurat_Date = new com.toedter.calendar.JDateChooser();
        CPNS_Profesi_TF = new javax.swing.JTextField();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        CPNS_tanggalEdit = new javax.swing.JLabel();
        CPNS_NipBaru_TF = new javax.swing.JTextField();
        CPNS_NipLama_TF = new javax.swing.JTextField();
        jLabel14 = new javax.swing.JLabel();
        CPNS_TglLhr_Date = new com.toedter.calendar.JDateChooser();
        jLabel49 = new javax.swing.JLabel();
        CPNS_Sekolah_TF = new javax.swing.JTextField();
        jLabel65 = new javax.swing.JLabel();
        CPNS_MasaKerjaBulan_TF = new javax.swing.JTextField();
        CPNS_Golongan_TF = new javax.swing.JTextField();
        jLabel68 = new javax.swing.JLabel();
        jLabel69 = new javax.swing.JLabel();
        CPNS_MasaKerjaTahun_TF = new javax.swing.JTextField();
        jLabel70 = new javax.swing.JLabel();
        jLabel71 = new javax.swing.JLabel();
        CPNS_Berijazah_TF = new javax.swing.JTextField();
        jLabel73 = new javax.swing.JLabel();
        CPNS_kode_ope = new javax.swing.JLabel();
        jLabel95 = new javax.swing.JLabel();
        jLabel96 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        CPNS_tmt_cpns = new com.toedter.calendar.JDateChooser();
        jLabel109 = new javax.swing.JLabel();
        SK_PangkatTerakhir = new javax.swing.JPanel();
        jLabel15 = new javax.swing.JLabel();
        PT_Nama_TF = new javax.swing.JTextField();
        jLabel16 = new javax.swing.JLabel();
        jLabel19 = new javax.swing.JLabel();
        jLabel21 = new javax.swing.JLabel();
        jLabel22 = new javax.swing.JLabel();
        PT_Pend_TF = new javax.swing.JTextField();
        PT_TglLhr_Date = new com.toedter.calendar.JDateChooser();
        PT_TmpLhr_TF = new javax.swing.JTextField();
        PT_NipBaru_TF = new javax.swing.JTextField();
        jLabel23 = new javax.swing.JLabel();
        jLabel24 = new javax.swing.JLabel();
        PT_NipLama_TF = new javax.swing.JTextField();
        PT_update_button = new javax.swing.JButton();
        PT_NoSurat_TF = new javax.swing.JTextField();
        jLabel28 = new javax.swing.JLabel();
        PT_GolBr_TF = new javax.swing.JTextField();
        PT_TmtBr_Date = new com.toedter.calendar.JDateChooser();
        jLabel31 = new javax.swing.JLabel();
        jLabel32 = new javax.swing.JLabel();
        PT_MsKerjaGolBln_TF = new javax.swing.JTextField();
        PT_GajiPokok_TF = new javax.swing.JTextField();
        jLabel33 = new javax.swing.JLabel();
        jLabel76 = new javax.swing.JLabel();
        jLabel77 = new javax.swing.JLabel();
        PT_MsKerjaGolThn_TF = new javax.swing.JTextField();
        jLabel78 = new javax.swing.JLabel();
        PT_Profesi_TF = new javax.swing.JTextField();
        jLabel20 = new javax.swing.JLabel();
        PT_Sekolah_TF = new javax.swing.JTextField();
        jLabel97 = new javax.swing.JLabel();
        PT_tanggalEdit = new javax.swing.JLabel();
        jLabel98 = new javax.swing.JLabel();
        PT_kode_ope = new javax.swing.JLabel();
        PT_PngktBr_TF = new javax.swing.JComboBox();
        jLabel110 = new javax.swing.JLabel();
        SPTKG_Terakhir = new javax.swing.JPanel();
        jLabel17 = new javax.swing.JLabel();
        jLabel34 = new javax.swing.JLabel();
        jLabel35 = new javax.swing.JLabel();
        SPTKG_Nama_TF = new javax.swing.JTextField();
        SPTKG_TmpSurat_TF = new javax.swing.JTextField();
        SPTKG_TglSurat_TF = new com.toedter.calendar.JDateChooser();
        SPTKG_NoSurat_TF = new javax.swing.JTextField();
        jLabel42 = new javax.swing.JLabel();
        SPTKG_NipLama_TF = new javax.swing.JTextField();
        SPTKG_NipBaru_TF = new javax.swing.JTextField();
        jLabel43 = new javax.swing.JLabel();
        SPTKG_update_button = new javax.swing.JButton();
        jLabel36 = new javax.swing.JLabel();
        SPTKG_GolBr_TF = new javax.swing.JTextField();
        jLabel39 = new javax.swing.JLabel();
        SPTKG_Sekolah_TF = new javax.swing.JTextField();
        SPTKG_GajiLama_TF = new javax.swing.JTextField();
        jLabel40 = new javax.swing.JLabel();
        jLabel41 = new javax.swing.JLabel();
        SPTKG_GajiBaru_TF = new javax.swing.JTextField();
        SPTKG_TmtBr_TF = new com.toedter.calendar.JDateChooser();
        jLabel44 = new javax.swing.JLabel();
        jLabel80 = new javax.swing.JLabel();
        jLabel81 = new javax.swing.JLabel();
        jLabel82 = new javax.swing.JLabel();
        jLabel83 = new javax.swing.JLabel();
        jLabel84 = new javax.swing.JLabel();
        jLabel99 = new javax.swing.JLabel();
        SPTKG_tanggalEdit = new javax.swing.JLabel();
        jLabel100 = new javax.swing.JLabel();
        SPTKG_kode_ope = new javax.swing.JLabel();
        SPTKG_PangkatBr_TF = new javax.swing.JComboBox();
        jLabel111 = new javax.swing.JLabel();
        SK_Karpeg = new javax.swing.JPanel();
        jLabel45 = new javax.swing.JLabel();
        Karpeg_Nama_TF = new javax.swing.JTextField();
        jLabel46 = new javax.swing.JLabel();
        jLabel48 = new javax.swing.JLabel();
        Karpeg_TMT_Date = new com.toedter.calendar.JDateChooser();
        Karpeg_NipBaru_TF = new javax.swing.JTextField();
        jLabel51 = new javax.swing.JLabel();
        jLabel52 = new javax.swing.JLabel();
        Karpeg_NipLama_TF = new javax.swing.JTextField();
        Karpeg_simpan_button = new javax.swing.JButton();
        Karpeg_NoSurat_TF = new javax.swing.JTextField();
        Karpeg_TglLhr_Date = new com.toedter.calendar.JDateChooser();
        jLabel85 = new javax.swing.JLabel();
        jLabel86 = new javax.swing.JLabel();
        jLabel101 = new javax.swing.JLabel();
        Karpeg_tanggalEdit = new javax.swing.JLabel();
        jLabel102 = new javax.swing.JLabel();
        Karpeg_kode_ope = new javax.swing.JLabel();
        jLabel112 = new javax.swing.JLabel();
        Surat_Nikah = new javax.swing.JPanel();
        jLabel47 = new javax.swing.JLabel();
        SN_NoSurat_TF = new javax.swing.JTextField();
        SN_NamaSuami_TF = new javax.swing.JTextField();
        SN_NamaIstri_TF = new javax.swing.JTextField();
        jLabel53 = new javax.swing.JLabel();
        jLabel54 = new javax.swing.JLabel();
        jLabel55 = new javax.swing.JLabel();
        SN_TglNikah_Date = new com.toedter.calendar.JDateChooser();
        SN_simpan_button = new javax.swing.JButton();
        jLabel103 = new javax.swing.JLabel();
        SN_tanggalEdit = new javax.swing.JLabel();
        jLabel104 = new javax.swing.JLabel();
        SN_kode_ope = new javax.swing.JLabel();
        jLabel94 = new javax.swing.JLabel();
        jLabel113 = new javax.swing.JLabel();
        KK = new javax.swing.JPanel();
        jScrollPane2 = new javax.swing.JScrollPane();
        jPanel8 = new javax.swing.JPanel();
        jLabel56 = new javax.swing.JLabel();
        KK_NamaKK_TF = new javax.swing.JTextField();
        KK_Alamat_TF = new javax.swing.JTextField();
        KK_RT_TF = new javax.swing.JTextField();
        KK_RW_TF = new javax.swing.JTextField();
        KK_KelDesa_TF = new javax.swing.JTextField();
        jLabel60 = new javax.swing.JLabel();
        jLabel58 = new javax.swing.JLabel();
        jLabel57 = new javax.swing.JLabel();
        jLabel61 = new javax.swing.JLabel();
        jLabel62 = new javax.swing.JLabel();
        jLabel64 = new javax.swing.JLabel();
        jLabel63 = new javax.swing.JLabel();
        KK_Provinsi_TF = new javax.swing.JTextField();
        KK_KodePos_TF = new javax.swing.JTextField();
        KK_KabKota_TF = new javax.swing.JTextField();
        KK_Kec_TF = new javax.swing.JTextField();
        jLabel59 = new javax.swing.JLabel();
        KK_NoKK_TF = new javax.swing.JTextField();
        jScrollPane3 = new javax.swing.JScrollPane();
        KK_TabelAnggotaKel_Tablel = new javax.swing.JTable();
        KK_SimpanKK_button = new javax.swing.JButton();
        KK_TambahAnggota_button = new javax.swing.JButton();
        jLabel105 = new javax.swing.JLabel();
        KK_tanggalEdit = new javax.swing.JLabel();
        jLabel106 = new javax.swing.JLabel();
        KK_kode_ope = new javax.swing.JLabel();
        jLabel114 = new javax.swing.JLabel();
        jLabel115 = new javax.swing.JLabel();
        tempat_bekerja = new javax.swing.JPanel();
        jLabel116 = new javax.swing.JLabel();
        jLabel66 = new javax.swing.JLabel();
        tmt_bkrja_no_instansi = new javax.swing.JTextField();
        tmt_bkrja_nama_kepala = new javax.swing.JTextField();
        jLabel67 = new javax.swing.JLabel();
        jLabel72 = new javax.swing.JLabel();
        tmt_bkrja_nip_kepala = new javax.swing.JTextField();
        tmt_bkrja_nip_peg = new javax.swing.JTextField();
        jLabel75 = new javax.swing.JLabel();
        jLabel79 = new javax.swing.JLabel();
        tmt_bkrja_nama_peg = new javax.swing.JTextField();
        tmt_bkrja_simpan = new javax.swing.JButton();
        jLabel117 = new javax.swing.JLabel();
        tmt_bkrja_nm_instansi = new javax.swing.JTextField();
        jLabel118 = new javax.swing.JLabel();
        tmt_bekerja_golongan = new javax.swing.JTextField();
        jLabel119 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        TP_Kode_Label = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        TP_Nama_Label = new javax.swing.JLabel();
        time = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();
        jLabel108 = new javax.swing.JLabel();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setResizable(false);
        getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        KK_Internal.setTitle("Tambah Anggota Keluarga");
        KK_Internal.getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jPanel4.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel9.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel9.setText("FORM PENGISIAN TABEL KK");
        jLabel9.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
        jPanel4.add(jLabel9, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 11, 740, 24));

        jPanel5.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
        jPanel5.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel18.setText("Nama Lengkap");
        jPanel5.add(jLabel18, new org.netbeans.lib.awtextra.AbsoluteConstraints(11, 15, -1, -1));

        jLabel25.setText("NIK");
        jPanel5.add(jLabel25, new org.netbeans.lib.awtextra.AbsoluteConstraints(11, 41, -1, -1));

        jLabel26.setText("Jenis Kelamin");
        jPanel5.add(jLabel26, new org.netbeans.lib.awtextra.AbsoluteConstraints(11, 67, -1, -1));

        jLabel29.setText("Tempat Lahir");
        jPanel5.add(jLabel29, new org.netbeans.lib.awtextra.AbsoluteConstraints(11, 93, -1, -1));

        jLabel30.setText("Tanggal Lahir");
        jPanel5.add(jLabel30, new org.netbeans.lib.awtextra.AbsoluteConstraints(11, 116, -1, -1));

        jLabel37.setText("Agama");
        jPanel5.add(jLabel37, new org.netbeans.lib.awtextra.AbsoluteConstraints(11, 142, -1, -1));

        jLabel38.setText("Pendidikan");
        jPanel5.add(jLabel38, new org.netbeans.lib.awtextra.AbsoluteConstraints(11, 176, -1, -1));

        jLabel50.setText("Pekerjaan");
        jPanel5.add(jLabel50, new org.netbeans.lib.awtextra.AbsoluteConstraints(11, 202, -1, -1));

        jLabel87.setText("Status Perkawinan");
        jPanel5.add(jLabel87, new org.netbeans.lib.awtextra.AbsoluteConstraints(11, 230, -1, -1));

        jLabel88.setText("Hubungan Keluarga");
        jPanel5.add(jLabel88, new org.netbeans.lib.awtextra.AbsoluteConstraints(393, 15, -1, -1));

        jLabel89.setText("Kewarganegaraan");
        jPanel5.add(jLabel89, new org.netbeans.lib.awtextra.AbsoluteConstraints(393, 41, -1, -1));

        jLabel90.setText("No Paspor");
        jPanel5.add(jLabel90, new org.netbeans.lib.awtextra.AbsoluteConstraints(393, 67, -1, -1));

        jLabel91.setText("Nama Ayah");
        jPanel5.add(jLabel91, new org.netbeans.lib.awtextra.AbsoluteConstraints(393, 119, -1, -1));

        jLabel92.setText("Nama Ibu");
        jPanel5.add(jLabel92, new org.netbeans.lib.awtextra.AbsoluteConstraints(393, 145, -1, -1));

        AK_Batal_button.setText("BATAL");
        AK_Batal_button.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                AK_Batal_buttonActionPerformed(evt);
            }
        });
        jPanel5.add(AK_Batal_button, new org.netbeans.lib.awtextra.AbsoluteConstraints(519, 198, -1, -1));

        AK_Simpan_button.setText("SIMPAN");
        AK_Simpan_button.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                AK_Simpan_buttonActionPerformed(evt);
            }
        });
        jPanel5.add(AK_Simpan_button, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 198, -1, -1));
        jPanel5.add(AK_Nama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(125, 12, 182, -1));
        jPanel5.add(AK_NIK_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(125, 38, 182, -1));
        jPanel5.add(AK_TempatLahir_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(125, 90, 182, -1));

        AK_JK_Combo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "L", "P" }));
        jPanel5.add(AK_JK_Combo, new org.netbeans.lib.awtextra.AbsoluteConstraints(125, 64, -1, -1));
        jPanel5.add(AK_TanggalLahir_Date, new org.netbeans.lib.awtextra.AbsoluteConstraints(125, 116, 123, -1));

        AK_NoPaspor_TF.setText("-");
        jPanel5.add(AK_NoPaspor_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(505, 64, 182, -1));
        jPanel5.add(AK_NamaAyah_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(505, 116, 182, -1));
        jPanel5.add(AK_NamaIbu_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(505, 142, 182, -1));

        AK_Agama_Combo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "ISLAM", "KRISTEN", "KATOLIK", "HINDU", "BUDHA", "KHONGHUCU" }));
        jPanel5.add(AK_Agama_Combo, new org.netbeans.lib.awtextra.AbsoluteConstraints(125, 142, -1, -1));

        AK_Pendidikan_Combo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "TIDAK/BLM SEKOLAH", "TK/SEDERAJAT", "SD/SEDERAJAT", "SLTP/SEDERAJAT", "SLTA/SEDERAJAT", "DIPLOMA III", "DIPLOMA IV/STRATA I", "TIDAK TAMAT TK/SEDERAJAT", "TIDAK TAMAT SD/SEDERAJAT", "TIDAK TAMAT SLTP/SEDERAJAT", "TIDAK TAMAT SLTA/SEDERAJAT" }));
        jPanel5.add(AK_Pendidikan_Combo, new org.netbeans.lib.awtextra.AbsoluteConstraints(125, 173, -1, -1));

        AK_Pekerjaan_Combo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "PEGAWAI NEGRI SIPIL", "KARYAWAN SWASTA", "MENGURUS RUMAH TANGGA", "PELAJAR/MAHASISWA", "WIRASWASTA", "Lainnya..." }));
        AK_Pekerjaan_Combo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                AK_Pekerjaan_ComboActionPerformed(evt);
            }
        });
        jPanel5.add(AK_Pekerjaan_Combo, new org.netbeans.lib.awtextra.AbsoluteConstraints(125, 199, 134, -1));

        AK_StatusKawin_Combo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "KAWIN", "BELUM KAWIN" }));
        jPanel5.add(AK_StatusKawin_Combo, new org.netbeans.lib.awtextra.AbsoluteConstraints(125, 227, -1, -1));

        AK_HubKeluarga_Combo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "KEPALA KELUARGA", "SUAMI", "ISTRI", "ANAK KANDUNG", "ANAK ANGKAT", "ANAK TIRI", "SAUDARA" }));
        jPanel5.add(AK_HubKeluarga_Combo, new org.netbeans.lib.awtextra.AbsoluteConstraints(505, 12, -1, -1));

        AK_Kewarganegaraan_Combo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "WNI", "WNA" }));
        jPanel5.add(AK_Kewarganegaraan_Combo, new org.netbeans.lib.awtextra.AbsoluteConstraints(505, 38, -1, -1));

        AK_Pekerjaan_TF.setText("-");
        jPanel5.add(AK_Pekerjaan_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(265, 199, 118, -1));

        AK_NoKitasKitap_TF.setText("-");
        jPanel5.add(AK_NoKitasKitap_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(505, 90, 182, -1));

        jLabel93.setText("No Kitas/Kitap");
        jPanel5.add(jLabel93, new org.netbeans.lib.awtextra.AbsoluteConstraints(393, 93, -1, -1));

        jLabel107.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/bg1.png"))); // NOI18N
        jPanel5.add(jLabel107, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 740, 300));

        jPanel4.add(jPanel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 41, 740, 300));

        jLabel13.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/bg1.png"))); // NOI18N
        jPanel4.add(jLabel13, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 760, 350));

        KK_Internal.getContentPane().add(jPanel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 760, 350));

        getContentPane().add(KK_Internal, new org.netbeans.lib.awtextra.AbsoluteConstraints(60, 100, 780, 380));

        jPanel2.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));

        jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/header2.jpg"))); // NOI18N
        jLabel1.setText("jLabel1");

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 875, Short.MAX_VALUE)
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, 179, Short.MAX_VALUE)
                .addContainerGap())
        );

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, 182, javax.swing.GroupLayout.PREFERRED_SIZE)
        );

        getContentPane().add(jPanel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 880, 180));

        jPanel3.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 24));
        jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel2.setText("EDIT PNS");
        jPanel3.add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 50, 857, -1));

        SK_CPNS.setBorder(javax.swing.BorderFactory.createEtchedBorder(javax.swing.border.EtchedBorder.RAISED));
        SK_CPNS.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        CPNS_update_button.setFont(new java.awt.Font("Tahoma", 1, 14));
        CPNS_update_button.setText("UPDATE");
        CPNS_update_button.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                CPNS_update_buttonActionPerformed(evt);
            }
        });
        SK_CPNS.add(CPNS_update_button, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 300, -1, -1));

        jLabel3.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel3.setText("Nomor Surat");
        SK_CPNS.add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 80, -1, -1));
        SK_CPNS.add(CPNS_TmpBuatSurat_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 110, 110, -1));

        jLabel4.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel4.setText("Tempat ,Tanggal Surat");
        SK_CPNS.add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 110, -1, -1));
        SK_CPNS.add(CPNS_NoSurat_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 80, 230, -1));

        CPNS_nama_TF.setEditable(false);
        SK_CPNS.add(CPNS_nama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 140, 230, -1));

        jLabel6.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel6.setText("Nama");
        SK_CPNS.add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 140, -1, -1));
        SK_CPNS.add(CPNS_TmpLhr_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 170, 110, -1));

        jLabel7.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel7.setText("Tempat, Tanggal Lahir");
        SK_CPNS.add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 170, -1, -1));

        CPNS_TglSurat_Date.setDateFormatString("dd-MM-yyyy");
        SK_CPNS.add(CPNS_TglSurat_Date, new org.netbeans.lib.awtextra.AbsoluteConstraints(300, 110, 110, -1));
        SK_CPNS.add(CPNS_Profesi_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 200, 230, -1));

        jLabel11.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel11.setText("Profesi/Jabatan");
        SK_CPNS.add(jLabel11, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 200, -1, -1));

        jLabel12.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel12.setText("Bulan");
        SK_CPNS.add(jLabel12, new org.netbeans.lib.awtextra.AbsoluteConstraints(730, 80, 50, 20));

        CPNS_tanggalEdit.setFont(new java.awt.Font("Tahoma", 1, 14));
        CPNS_tanggalEdit.setForeground(new java.awt.Color(255, 0, 0));
        CPNS_tanggalEdit.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        CPNS_tanggalEdit.setText("--tanggal--");
        SK_CPNS.add(CPNS_tanggalEdit, new org.netbeans.lib.awtextra.AbsoluteConstraints(670, 350, 100, -1));

        CPNS_NipBaru_TF.setEditable(false);
        SK_CPNS.add(CPNS_NipBaru_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(580, 170, 250, -1));

        CPNS_NipLama_TF.setEditable(false);
        SK_CPNS.add(CPNS_NipLama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(580, 140, 150, -1));

        jLabel14.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel14.setText("NIP Lama");
        SK_CPNS.add(jLabel14, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 140, -1, -1));

        CPNS_TglLhr_Date.setDateFormatString("dd-MM-yyyy");
        SK_CPNS.add(CPNS_TglLhr_Date, new org.netbeans.lib.awtextra.AbsoluteConstraints(300, 170, 110, -1));

        jLabel49.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel49.setText("Sekolah/Instansi");
        SK_CPNS.add(jLabel49, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 230, -1, -1));
        SK_CPNS.add(CPNS_Sekolah_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 230, 230, -1));

        jLabel65.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel65.setText("Golongan");
        SK_CPNS.add(jLabel65, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 110, -1, 20));
        SK_CPNS.add(CPNS_MasaKerjaBulan_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(680, 80, 40, -1));
        SK_CPNS.add(CPNS_Golongan_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(580, 110, 100, -1));

        jLabel68.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel68.setText("Tahun");
        SK_CPNS.add(jLabel68, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 80, 50, 20));

        jLabel69.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel69.setText("Masa Kerja");
        SK_CPNS.add(jLabel69, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 80, -1, 20));
        SK_CPNS.add(CPNS_MasaKerjaTahun_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(580, 80, 40, -1));

        jLabel70.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel70.setText("NIP baru");
        SK_CPNS.add(jLabel70, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 170, -1, -1));

        jLabel71.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel71.setText("Berijazah");
        SK_CPNS.add(jLabel71, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 200, -1, -1));
        SK_CPNS.add(CPNS_Berijazah_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(580, 200, 250, -1));

        jLabel73.setFont(new java.awt.Font("Tahoma", 1, 18));
        jLabel73.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel73.setText("SK CPNS");
        SK_CPNS.add(jLabel73, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 10, 840, 30));

        CPNS_kode_ope.setFont(new java.awt.Font("Tahoma", 1, 14));
        CPNS_kode_ope.setForeground(new java.awt.Color(255, 0, 0));
        CPNS_kode_ope.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        CPNS_kode_ope.setText("Kode");
        SK_CPNS.add(CPNS_kode_ope, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 350, 30, -1));

        jLabel95.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel95.setForeground(new java.awt.Color(255, 0, 0));
        jLabel95.setText("Editan Terakhir ");
        SK_CPNS.add(jLabel95, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 350, -1, -1));

        jLabel96.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel96.setForeground(new java.awt.Color(255, 0, 0));
        jLabel96.setText("Oleh");
        SK_CPNS.add(jLabel96, new org.netbeans.lib.awtextra.AbsoluteConstraints(780, 350, 30, -1));

        jLabel10.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel10.setText("TMT CPNS");
        SK_CPNS.add(jLabel10, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 260, -1, -1));

        CPNS_tmt_cpns.setDateFormatString("dd-MM-yyyy");
        SK_CPNS.add(CPNS_tmt_cpns, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 260, 230, -1));

        jLabel109.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/wall2.jpg"))); // NOI18N
        SK_CPNS.add(jLabel109, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 870, 380));

        Tab_PNS.addTab("SK_CPNS", SK_CPNS);

        SK_PangkatTerakhir.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel15.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel15.setText("Nomor Surat");
        SK_PangkatTerakhir.add(jLabel15, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 70, -1, -1));

        PT_Nama_TF.setEditable(false);
        SK_PangkatTerakhir.add(PT_Nama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 100, 230, -1));

        jLabel16.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel16.setText("Nama");
        SK_PangkatTerakhir.add(jLabel16, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 100, -1, -1));

        jLabel19.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel19.setText("Tempat, Tgl Lahir");
        SK_PangkatTerakhir.add(jLabel19, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 130, -1, -1));

        jLabel21.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel21.setText("Pendidikan");
        SK_PangkatTerakhir.add(jLabel21, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 220, -1, -1));

        jLabel22.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel22.setText("Sekolah/Instansi");
        SK_PangkatTerakhir.add(jLabel22, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 280, -1, -1));
        SK_PangkatTerakhir.add(PT_Pend_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 220, 120, -1));

        PT_TglLhr_Date.setDateFormatString("dd-MM-yyyy");
        SK_PangkatTerakhir.add(PT_TglLhr_Date, new org.netbeans.lib.awtextra.AbsoluteConstraints(290, 130, 120, -1));
        SK_PangkatTerakhir.add(PT_TmpLhr_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 130, 100, -1));

        PT_NipBaru_TF.setEditable(false);
        SK_PangkatTerakhir.add(PT_NipBaru_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 190, 230, -1));

        jLabel23.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel23.setText("NIP baru");
        SK_PangkatTerakhir.add(jLabel23, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 190, -1, -1));

        jLabel24.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel24.setText("NIP Lama");
        SK_PangkatTerakhir.add(jLabel24, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 160, -1, -1));

        PT_NipLama_TF.setEditable(false);
        SK_PangkatTerakhir.add(PT_NipLama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 160, 120, -1));

        PT_update_button.setFont(new java.awt.Font("Tahoma", 1, 14));
        PT_update_button.setText("UPDATE");
        PT_update_button.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                PT_update_buttonActionPerformed(evt);
            }
        });
        SK_PangkatTerakhir.add(PT_update_button, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 300, -1, -1));
        SK_PangkatTerakhir.add(PT_NoSurat_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 70, 230, -1));

        jLabel28.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel28.setText("Pangkat, Gol Baru");
        SK_PangkatTerakhir.add(jLabel28, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 70, -1, -1));
        SK_PangkatTerakhir.add(PT_GolBr_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(810, 70, 50, -1));

        PT_TmtBr_Date.setDateFormatString("dd-MM-yyyy");
        SK_PangkatTerakhir.add(PT_TmtBr_Date, new org.netbeans.lib.awtextra.AbsoluteConstraints(580, 100, 180, -1));

        jLabel31.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel31.setText("TMT baru");
        SK_PangkatTerakhir.add(jLabel31, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 100, -1, -1));

        jLabel32.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel32.setText("Mas kerja Gol");
        SK_PangkatTerakhir.add(jLabel32, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 130, -1, -1));
        SK_PangkatTerakhir.add(PT_MsKerjaGolBln_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 130, 50, -1));
        SK_PangkatTerakhir.add(PT_GajiPokok_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(580, 160, 230, -1));

        jLabel33.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel33.setText("Bulan");
        SK_PangkatTerakhir.add(jLabel33, new org.netbeans.lib.awtextra.AbsoluteConstraints(750, 130, -1, -1));

        jLabel76.setFont(new java.awt.Font("Tahoma", 1, 18));
        jLabel76.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel76.setText("SK PANGKAT TERAKHIR");
        SK_PangkatTerakhir.add(jLabel76, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 10, 840, 30));

        jLabel77.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel77.setText("Gaji Pokok");
        SK_PangkatTerakhir.add(jLabel77, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 160, -1, -1));
        SK_PangkatTerakhir.add(PT_MsKerjaGolThn_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(580, 130, 50, -1));

        jLabel78.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel78.setText("Tahun");
        SK_PangkatTerakhir.add(jLabel78, new org.netbeans.lib.awtextra.AbsoluteConstraints(640, 130, -1, -1));
        SK_PangkatTerakhir.add(PT_Profesi_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 250, 230, -1));

        jLabel20.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel20.setText("Profesi/Jabatan");
        SK_PangkatTerakhir.add(jLabel20, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 250, -1, -1));
        SK_PangkatTerakhir.add(PT_Sekolah_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 280, 230, -1));

        jLabel97.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel97.setForeground(new java.awt.Color(255, 0, 0));
        jLabel97.setText("Editan Terakhir ");
        SK_PangkatTerakhir.add(jLabel97, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 350, -1, -1));

        PT_tanggalEdit.setFont(new java.awt.Font("Tahoma", 1, 14));
        PT_tanggalEdit.setForeground(new java.awt.Color(255, 0, 0));
        PT_tanggalEdit.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        PT_tanggalEdit.setText("--tanggal--");
        SK_PangkatTerakhir.add(PT_tanggalEdit, new org.netbeans.lib.awtextra.AbsoluteConstraints(670, 350, 100, -1));

        jLabel98.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel98.setForeground(new java.awt.Color(255, 0, 0));
        jLabel98.setText("Oleh");
        SK_PangkatTerakhir.add(jLabel98, new org.netbeans.lib.awtextra.AbsoluteConstraints(780, 350, 30, -1));

        PT_kode_ope.setFont(new java.awt.Font("Tahoma", 1, 14));
        PT_kode_ope.setForeground(new java.awt.Color(255, 0, 0));
        PT_kode_ope.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        PT_kode_ope.setText("Kode");
        SK_PangkatTerakhir.add(PT_kode_ope, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 350, 30, -1));

        PT_PngktBr_TF.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Pangkat Pengatur Muda", "Pangkat Pengatur Muda Tingat 1", "Pangkat Pengatur", "Pangkat Pengatur Tingkat 1", "Pangkat Penata Muda", "Pangkat Penata Muda Tingkat 1", "Pangkat Penata", "Pangkat Penata Tingkat 1", "Pangkat Pembina", "Pangkat Pembina Tingkat 1", "Pangkat Pembina Utama Muda", "Pangkat Pembina Utama Madya", "Pangkat Pembina Utama" }));
        PT_PngktBr_TF.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                PT_PngktBr_TFActionPerformed(evt);
            }
        });
        SK_PangkatTerakhir.add(PT_PngktBr_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(580, 70, 220, -1));

        jLabel110.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/wall2.jpg"))); // NOI18N
        SK_PangkatTerakhir.add(jLabel110, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 870, 380));

        Tab_PNS.addTab("SK_PangkatTerakhir", SK_PangkatTerakhir);

        SPTKG_Terakhir.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel17.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel17.setText("Nomor Surat");
        SPTKG_Terakhir.add(jLabel17, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 50, -1, -1));

        jLabel34.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel34.setText("Tmp, Tnggl Pembuatan");
        SPTKG_Terakhir.add(jLabel34, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 80, -1, -1));

        jLabel35.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel35.setText("Nama");
        SPTKG_Terakhir.add(jLabel35, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 110, -1, -1));

        SPTKG_Nama_TF.setEditable(false);
        SPTKG_Terakhir.add(SPTKG_Nama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 110, 230, -1));
        SPTKG_Terakhir.add(SPTKG_TmpSurat_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 80, 120, -1));

        SPTKG_TglSurat_TF.setDateFormatString("dd-MM-yyyy");
        SPTKG_Terakhir.add(SPTKG_TglSurat_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(310, 80, 100, -1));
        SPTKG_Terakhir.add(SPTKG_NoSurat_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 50, 230, -1));

        jLabel42.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel42.setText("NIP Lama");
        SPTKG_Terakhir.add(jLabel42, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 140, -1, -1));

        SPTKG_NipLama_TF.setEditable(false);
        SPTKG_Terakhir.add(SPTKG_NipLama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 140, 120, -1));

        SPTKG_NipBaru_TF.setEditable(false);
        SPTKG_Terakhir.add(SPTKG_NipBaru_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 170, 230, -1));

        jLabel43.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel43.setText("NIP baru");
        SPTKG_Terakhir.add(jLabel43, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 170, -1, -1));

        SPTKG_update_button.setFont(new java.awt.Font("Tahoma", 1, 14));
        SPTKG_update_button.setText("UPDATE");
        SPTKG_update_button.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                SPTKG_update_buttonActionPerformed(evt);
            }
        });
        SPTKG_Terakhir.add(SPTKG_update_button, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 300, -1, -1));

        jLabel36.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel36.setText("Pangkat,Gol Baru");
        SPTKG_Terakhir.add(jLabel36, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 200, -1, -1));

        SPTKG_GolBr_TF.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                SPTKG_GolBr_TFActionPerformed(evt);
            }
        });
        SPTKG_Terakhir.add(SPTKG_GolBr_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 200, 70, -1));

        jLabel39.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel39.setText("Kantor/Tempat");
        SPTKG_Terakhir.add(jLabel39, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 230, -1, -1));
        SPTKG_Terakhir.add(SPTKG_Sekolah_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 230, 230, -1));
        SPTKG_Terakhir.add(SPTKG_GajiLama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(650, 50, 170, -1));

        jLabel40.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel40.setText("Gaji Pokok Lama");
        SPTKG_Terakhir.add(jLabel40, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 50, -1, -1));

        jLabel41.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel41.setText("Gaji Pokok Baru");
        SPTKG_Terakhir.add(jLabel41, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 80, -1, -1));
        SPTKG_Terakhir.add(SPTKG_GajiBaru_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(650, 80, 170, -1));

        SPTKG_TmtBr_TF.setDateFormatString("dd-MM-yyyy");
        SPTKG_Terakhir.add(SPTKG_TmtBr_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(650, 110, 170, -1));

        jLabel44.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel44.setText("Rp");
        SPTKG_Terakhir.add(jLabel44, new org.netbeans.lib.awtextra.AbsoluteConstraints(620, 80, -1, -1));

        jLabel80.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel80.setText("TMT Gaji Pokok baru");
        SPTKG_Terakhir.add(jLabel80, new org.netbeans.lib.awtextra.AbsoluteConstraints(460, 110, -1, -1));

        jLabel81.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel81.setText(", -");
        SPTKG_Terakhir.add(jLabel81, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 80, -1, -1));

        jLabel82.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel82.setText("Rp");
        SPTKG_Terakhir.add(jLabel82, new org.netbeans.lib.awtextra.AbsoluteConstraints(620, 50, -1, -1));

        jLabel83.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel83.setText(", -");
        SPTKG_Terakhir.add(jLabel83, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 50, -1, -1));

        jLabel84.setFont(new java.awt.Font("Tahoma", 1, 18));
        jLabel84.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel84.setText("SPTKG TERAKHIR");
        SPTKG_Terakhir.add(jLabel84, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 10, 840, 30));

        jLabel99.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel99.setForeground(new java.awt.Color(255, 0, 0));
        jLabel99.setText("Editan Terakhir ");
        SPTKG_Terakhir.add(jLabel99, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 350, -1, -1));

        SPTKG_tanggalEdit.setFont(new java.awt.Font("Tahoma", 1, 14));
        SPTKG_tanggalEdit.setForeground(new java.awt.Color(255, 0, 0));
        SPTKG_tanggalEdit.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        SPTKG_tanggalEdit.setText("--tanggal--");
        SPTKG_Terakhir.add(SPTKG_tanggalEdit, new org.netbeans.lib.awtextra.AbsoluteConstraints(670, 350, 100, -1));

        jLabel100.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel100.setForeground(new java.awt.Color(255, 0, 0));
        jLabel100.setText("Oleh");
        SPTKG_Terakhir.add(jLabel100, new org.netbeans.lib.awtextra.AbsoluteConstraints(780, 350, 30, -1));

        SPTKG_kode_ope.setFont(new java.awt.Font("Tahoma", 1, 14));
        SPTKG_kode_ope.setForeground(new java.awt.Color(255, 0, 0));
        SPTKG_kode_ope.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        SPTKG_kode_ope.setText("Kode");
        SPTKG_Terakhir.add(SPTKG_kode_ope, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 350, 30, -1));

        SPTKG_PangkatBr_TF.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Pangkat Pengatur Muda", "Pangkat Pengatur Muda Tingat 1", "Pangkat Pengatur", "Pangkat Pengatur Tingkat 1", "Pangkat Penata Muda", "Pangkat Penata Muda Tingkat 1", "Pangkat Penata", "Pangkat Penata Tingkat 1", "Pangkat Pembina", "Pangkat Pembina Tingkat 1", "Pangkat Pembina Utama Muda", "Pangkat Pembina Utama Madya", "Pangkat Pembina Utama" }));
        SPTKG_PangkatBr_TF.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                SPTKG_PangkatBr_TFActionPerformed(evt);
            }
        });
        SPTKG_Terakhir.add(SPTKG_PangkatBr_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 200, 230, -1));

        jLabel111.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/wall2.jpg"))); // NOI18N
        SPTKG_Terakhir.add(jLabel111, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 870, 380));

        Tab_PNS.addTab("SPTKG_Terakhir", SPTKG_Terakhir);

        SK_Karpeg.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel45.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel45.setText("Nomor Surat");
        SK_Karpeg.add(jLabel45, new org.netbeans.lib.awtextra.AbsoluteConstraints(230, 50, -1, -1));

        Karpeg_Nama_TF.setEditable(false);
        SK_Karpeg.add(Karpeg_Nama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 80, 230, -1));

        jLabel46.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel46.setText("Nama");
        SK_Karpeg.add(jLabel46, new org.netbeans.lib.awtextra.AbsoluteConstraints(230, 80, -1, -1));

        jLabel48.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel48.setText("Tanggal Lahir");
        SK_Karpeg.add(jLabel48, new org.netbeans.lib.awtextra.AbsoluteConstraints(230, 170, -1, -1));

        Karpeg_TMT_Date.setDateFormatString("dd-MM-yyyy");
        SK_Karpeg.add(Karpeg_TMT_Date, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 200, 230, -1));

        Karpeg_NipBaru_TF.setEditable(false);
        SK_Karpeg.add(Karpeg_NipBaru_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 140, 230, -1));

        jLabel51.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel51.setText("NIP baru");
        SK_Karpeg.add(jLabel51, new org.netbeans.lib.awtextra.AbsoluteConstraints(230, 140, -1, -1));

        jLabel52.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel52.setText("NIP Lama");
        SK_Karpeg.add(jLabel52, new org.netbeans.lib.awtextra.AbsoluteConstraints(230, 110, -1, -1));

        Karpeg_NipLama_TF.setEditable(false);
        SK_Karpeg.add(Karpeg_NipLama_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 110, 120, -1));

        Karpeg_simpan_button.setFont(new java.awt.Font("Tahoma", 1, 14));
        Karpeg_simpan_button.setText("UPDATE");
        Karpeg_simpan_button.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                Karpeg_simpan_buttonActionPerformed(evt);
            }
        });
        SK_Karpeg.add(Karpeg_simpan_button, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 300, -1, -1));
        SK_Karpeg.add(Karpeg_NoSurat_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 50, 230, -1));

        Karpeg_TglLhr_Date.setDateFormatString("dd-MM-yyyy");
        SK_Karpeg.add(Karpeg_TglLhr_Date, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 170, 230, -1));

        jLabel85.setFont(new java.awt.Font("Tahoma", 1, 18));
        jLabel85.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel85.setText("SK KARPEG");
        SK_Karpeg.add(jLabel85, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 10, 840, 30));

        jLabel86.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel86.setText("TMT CPNS");
        SK_Karpeg.add(jLabel86, new org.netbeans.lib.awtextra.AbsoluteConstraints(230, 200, -1, -1));

        jLabel101.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel101.setForeground(new java.awt.Color(255, 0, 0));
        jLabel101.setText("Editan Terakhir ");
        SK_Karpeg.add(jLabel101, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 350, -1, -1));

        Karpeg_tanggalEdit.setFont(new java.awt.Font("Tahoma", 1, 14));
        Karpeg_tanggalEdit.setForeground(new java.awt.Color(255, 0, 0));
        Karpeg_tanggalEdit.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        Karpeg_tanggalEdit.setText("--tanggal--");
        SK_Karpeg.add(Karpeg_tanggalEdit, new org.netbeans.lib.awtextra.AbsoluteConstraints(670, 350, 100, -1));

        jLabel102.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel102.setForeground(new java.awt.Color(255, 0, 0));
        jLabel102.setText("Oleh");
        SK_Karpeg.add(jLabel102, new org.netbeans.lib.awtextra.AbsoluteConstraints(780, 350, 30, -1));

        Karpeg_kode_ope.setFont(new java.awt.Font("Tahoma", 1, 14));
        Karpeg_kode_ope.setForeground(new java.awt.Color(255, 0, 0));
        Karpeg_kode_ope.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        Karpeg_kode_ope.setText("Kode");
        SK_Karpeg.add(Karpeg_kode_ope, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 350, 30, -1));

        jLabel112.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/wall2.jpg"))); // NOI18N
        SK_Karpeg.add(jLabel112, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 870, 380));

        Tab_PNS.addTab("SK_Karpeg", SK_Karpeg);

        Surat_Nikah.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel47.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel47.setText("Nomor Surat");
        Surat_Nikah.add(jLabel47, new org.netbeans.lib.awtextra.AbsoluteConstraints(240, 70, -1, -1));

        SN_NoSurat_TF.setEditable(false);
        Surat_Nikah.add(SN_NoSurat_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(400, 70, 230, -1));
        Surat_Nikah.add(SN_NamaSuami_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(400, 130, 230, -1));
        Surat_Nikah.add(SN_NamaIstri_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(400, 160, 230, -1));

        jLabel53.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel53.setText("Nama Istri");
        Surat_Nikah.add(jLabel53, new org.netbeans.lib.awtextra.AbsoluteConstraints(240, 160, -1, -1));

        jLabel54.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel54.setText("Nama Suami");
        Surat_Nikah.add(jLabel54, new org.netbeans.lib.awtextra.AbsoluteConstraints(240, 130, -1, -1));

        jLabel55.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel55.setText("Tanggal Nikah");
        Surat_Nikah.add(jLabel55, new org.netbeans.lib.awtextra.AbsoluteConstraints(240, 100, -1, -1));

        SN_TglNikah_Date.setDateFormatString("d MMM yyyy");
        Surat_Nikah.add(SN_TglNikah_Date, new org.netbeans.lib.awtextra.AbsoluteConstraints(400, 100, 230, -1));

        SN_simpan_button.setFont(new java.awt.Font("Tahoma", 1, 14));
        SN_simpan_button.setText("UPDATE");
        SN_simpan_button.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                SN_simpan_buttonActionPerformed(evt);
            }
        });
        Surat_Nikah.add(SN_simpan_button, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 300, -1, -1));

        jLabel103.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel103.setForeground(new java.awt.Color(255, 0, 0));
        jLabel103.setText("Editan Terakhir ");
        Surat_Nikah.add(jLabel103, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 350, -1, -1));

        SN_tanggalEdit.setFont(new java.awt.Font("Tahoma", 1, 14));
        SN_tanggalEdit.setForeground(new java.awt.Color(255, 0, 0));
        SN_tanggalEdit.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        SN_tanggalEdit.setText("--tanggal--");
        Surat_Nikah.add(SN_tanggalEdit, new org.netbeans.lib.awtextra.AbsoluteConstraints(670, 350, 100, -1));

        jLabel104.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel104.setForeground(new java.awt.Color(255, 0, 0));
        jLabel104.setText("Oleh");
        Surat_Nikah.add(jLabel104, new org.netbeans.lib.awtextra.AbsoluteConstraints(780, 350, 30, -1));

        SN_kode_ope.setFont(new java.awt.Font("Tahoma", 1, 14));
        SN_kode_ope.setForeground(new java.awt.Color(255, 0, 0));
        SN_kode_ope.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        SN_kode_ope.setText("Kode");
        Surat_Nikah.add(SN_kode_ope, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 350, 30, -1));

        jLabel94.setFont(new java.awt.Font("Tahoma", 1, 18));
        jLabel94.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel94.setText("SURAT NIKAH");
        Surat_Nikah.add(jLabel94, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 10, 840, 30));

        jLabel113.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/wall2.jpg"))); // NOI18N
        Surat_Nikah.add(jLabel113, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 870, 380));

        Tab_PNS.addTab("Surat Nikah", Surat_Nikah);

        KK.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jPanel8.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel56.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel56.setText("Nama kepala keluarga");
        jPanel8.add(jLabel56, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 40, -1, -1));
        jPanel8.add(KK_NamaKK_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 40, 230, -1));
        jPanel8.add(KK_Alamat_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 70, 230, -1));
        jPanel8.add(KK_RT_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 100, 40, -1));
        jPanel8.add(KK_RW_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(230, 100, 40, -1));
        jPanel8.add(KK_KelDesa_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 130, 120, -1));

        jLabel60.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel60.setText("Kelurahan/Desa");
        jPanel8.add(jLabel60, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 130, -1, -1));

        jLabel58.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel58.setText("RT/RW");
        jPanel8.add(jLabel58, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 100, -1, -1));

        jLabel57.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel57.setText("Alamat");
        jPanel8.add(jLabel57, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 70, -1, -1));

        jLabel61.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel61.setText("Kecamatan");
        jPanel8.add(jLabel61, new org.netbeans.lib.awtextra.AbsoluteConstraints(440, 40, -1, -1));

        jLabel62.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel62.setText("kabupaten/Kota");
        jPanel8.add(jLabel62, new org.netbeans.lib.awtextra.AbsoluteConstraints(440, 70, -1, -1));

        jLabel64.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel64.setText("Kode Pos");
        jPanel8.add(jLabel64, new org.netbeans.lib.awtextra.AbsoluteConstraints(440, 100, -1, -1));

        jLabel63.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel63.setText("Provinsi");
        jPanel8.add(jLabel63, new org.netbeans.lib.awtextra.AbsoluteConstraints(440, 130, -1, -1));
        jPanel8.add(KK_Provinsi_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(600, 130, 230, -1));
        jPanel8.add(KK_KodePos_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(600, 100, 230, -1));
        jPanel8.add(KK_KabKota_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(600, 70, 230, -1));
        jPanel8.add(KK_Kec_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(600, 40, 230, -1));

        jLabel59.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel59.setText("Nomor KK");
        jPanel8.add(jLabel59, new org.netbeans.lib.awtextra.AbsoluteConstraints(280, 10, -1, -1));

        KK_NoKK_TF.setEditable(false);
        jPanel8.add(KK_NoKK_TF, new org.netbeans.lib.awtextra.AbsoluteConstraints(370, 10, 230, -1));

        KK_TabelAnggotaKel_Tablel.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null}
            },
            new String [] {
                "No", "Nama lengkap", "NIK", "JK", "tempat Lahir", "Tanggal Lahir", "Agama", "Pendidikan", "Pekerjaan", "Status Perkawinan", "Hub Keluarga", "Kewarganegaraan", "No Paspor/Kitas", "No Kitas Kitab", "Nama Ayah", "Nama Ibu"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Integer.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        KK_TabelAnggotaKel_Tablel.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                KK_TabelAnggotaKel_TablelMouseClicked(evt);
            }
        });
        jScrollPane3.setViewportView(KK_TabelAnggotaKel_Tablel);

        jPanel8.add(jScrollPane3, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 160, 1050, 120));

        KK_SimpanKK_button.setFont(new java.awt.Font("Tahoma", 1, 11));
        KK_SimpanKK_button.setText("SIMPAN KK");
        KK_SimpanKK_button.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                KK_SimpanKK_buttonActionPerformed(evt);
            }
        });
        jPanel8.add(KK_SimpanKK_button, new org.netbeans.lib.awtextra.AbsoluteConstraints(480, 320, -1, -1));

        KK_TambahAnggota_button.setFont(new java.awt.Font("Tahoma", 1, 11));
        KK_TambahAnggota_button.setText("TAMBAH ANGGOTA KELUARGA");
        KK_TambahAnggota_button.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                KK_TambahAnggota_buttonActionPerformed(evt);
            }
        });
        jPanel8.add(KK_TambahAnggota_button, new org.netbeans.lib.awtextra.AbsoluteConstraints(590, 320, -1, -1));

        jLabel105.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel105.setForeground(new java.awt.Color(255, 0, 0));
        jLabel105.setText("Editan Terakhir ");
        jPanel8.add(jLabel105, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 330, -1, -1));

        KK_tanggalEdit.setFont(new java.awt.Font("Tahoma", 1, 14));
        KK_tanggalEdit.setForeground(new java.awt.Color(255, 0, 0));
        KK_tanggalEdit.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        KK_tanggalEdit.setText("--tanggal--");
        jPanel8.add(KK_tanggalEdit, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 330, 100, -1));

        jLabel106.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel106.setForeground(new java.awt.Color(255, 0, 0));
        jLabel106.setText("Oleh");
        jPanel8.add(jLabel106, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 330, 30, -1));

        KK_kode_ope.setFont(new java.awt.Font("Tahoma", 1, 14));
        KK_kode_ope.setForeground(new java.awt.Color(255, 0, 0));
        KK_kode_ope.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        KK_kode_ope.setText("Kode");
        jPanel8.add(KK_kode_ope, new org.netbeans.lib.awtextra.AbsoluteConstraints(270, 330, 30, -1));

        jLabel114.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/wall2.jpg"))); // NOI18N
        jPanel8.add(jLabel114, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 870, 360));

        jLabel115.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/wall2.jpg"))); // NOI18N
        jPanel8.add(jLabel115, new org.netbeans.lib.awtextra.AbsoluteConstraints(870, 0, 190, 360));

        jScrollPane2.setViewportView(jPanel8);

        KK.add(jScrollPane2, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 870, 380));

        Tab_PNS.addTab("KK", KK);

        tempat_bekerja.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

        jLabel116.setFont(new java.awt.Font("Tahoma", 1, 18));
        jLabel116.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel116.setText("Tempat Bekerja");
        tempat_bekerja.add(jLabel116, new org.netbeans.lib.awtextra.AbsoluteConstraints(20, 10, 840, 30));

        jLabel66.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel66.setText("Nama Sekolah/Instansi");
        tempat_bekerja.add(jLabel66, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 80, -1, 20));
        tempat_bekerja.add(tmt_bkrja_no_instansi, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 50, 230, -1));
        tempat_bekerja.add(tmt_bkrja_nama_kepala, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 110, 320, -1));

        jLabel67.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel67.setText("Nama Kepala Sekolah/Instansi");
        tempat_bekerja.add(jLabel67, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 110, -1, -1));

        jLabel72.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel72.setText("Pangkat/Golongan");
        tempat_bekerja.add(jLabel72, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 140, -1, -1));
        tempat_bekerja.add(tmt_bkrja_nip_kepala, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 170, 230, -1));

        tmt_bkrja_nip_peg.setEditable(false);
        tempat_bekerja.add(tmt_bkrja_nip_peg, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 230, 230, -1));

        jLabel75.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel75.setText("Nama Pegawai");
        tempat_bekerja.add(jLabel75, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 200, -1, -1));

        jLabel79.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel79.setText("NIP Pegawai");
        tempat_bekerja.add(jLabel79, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 230, -1, -1));

        tmt_bkrja_nama_peg.setEditable(false);
        tempat_bekerja.add(tmt_bkrja_nama_peg, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 200, 230, -1));

        tmt_bkrja_simpan.setFont(new java.awt.Font("Tahoma", 1, 14));
        tmt_bkrja_simpan.setText("Update");
        tmt_bkrja_simpan.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tmt_bkrja_simpanActionPerformed(evt);
            }
        });
        tempat_bekerja.add(tmt_bkrja_simpan, new org.netbeans.lib.awtextra.AbsoluteConstraints(340, 300, -1, -1));

        jLabel117.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel117.setText("Nomor Sekolah/Instansi");
        tempat_bekerja.add(jLabel117, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 50, -1, -1));
        tempat_bekerja.add(tmt_bkrja_nm_instansi, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 80, 320, -1));

        jLabel118.setFont(new java.awt.Font("Tahoma", 0, 14));
        jLabel118.setText("NIP Kepala Sekolah/Instansi");
        tempat_bekerja.add(jLabel118, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 170, -1, -1));
        tempat_bekerja.add(tmt_bekerja_golongan, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 140, 230, -1));

        jLabel119.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/wall2.jpg"))); // NOI18N
        tempat_bekerja.add(jLabel119, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 860, 370));

        Tab_PNS.addTab("Data tempat Bekerja", tempat_bekerja);

        jPanel3.add(Tab_PNS, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 90, 880, 410));

        jLabel5.setText("Selamat Datang,");
        jPanel3.add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 10, -1, -1));

        TP_Kode_Label.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        TP_Kode_Label.setText("Kode");
        jPanel3.add(TP_Kode_Label, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 10, 20, -1));

        jLabel8.setText("-");
        jPanel3.add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(140, 10, 10, -1));

        TP_Nama_Label.setText("Nama");
        jPanel3.add(TP_Nama_Label, new org.netbeans.lib.awtextra.AbsoluteConstraints(160, 10, 190, -1));

        time.setFont(new java.awt.Font("Tahoma", 1, 12));
        time.setText("time");
        jPanel3.add(time, new org.netbeans.lib.awtextra.AbsoluteConstraints(740, 10, -1, -1));

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
        jButton1.setText("Keluar");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        jPanel3.add(jButton1, new org.netbeans.lib.awtextra.AbsoluteConstraints(780, 60, -1, -1));

        jLabel108.setIcon(new javax.swing.ImageIcon(getClass().getResource("/PIcture/wall2.jpg"))); // NOI18N
        jPanel3.add(jLabel108, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 880, 110));

        getContentPane().add(jPanel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 180, 880, 500));

        pack();
        java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
        java.awt.Dimension dialogSize = getSize();
        setLocation((screenSize.width-dialogSize.width)/2,(screenSize.height-dialogSize.height)/2);
    }// </editor-fold>//GEN-END:initComponents

    private void CPNS_update_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CPNS_update_buttonActionPerformed
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

        SK_CPNS cpns = new SK_CPNS();
        cpns.setId_SuratCPNS(CPNS_NoSurat_TF.getText());
        cpns.setTempat_surat(CPNS_TmpBuatSurat_TF.getText());
        cpns.setTanggal_surat(sdf.format(CPNS_TglSurat_Date.getDate()));
        cpns.setNama_pemilik(CPNS_nama_TF.getText());
        cpns.setTempat_lahir(CPNS_TmpLhr_TF.getText());
        cpns.setTanggal_lahir(sdf.format(CPNS_TglLhr_Date.getDate()));
        cpns.setProfesi(CPNS_Profesi_TF.getText());
        cpns.setSekolah(CPNS_Sekolah_TF.getText());
        cpns.setMasa_kerja_tahun(CPNS_MasaKerjaTahun_TF.getText());
        cpns.setMasa_kerja_bulan(CPNS_MasaKerjaBulan_TF.getText());
        cpns.setGolongan(CPNS_Golongan_TF.getText());
        cpns.setNip_lama(CPNS_NipLama_TF.getText());
        cpns.setNip_baru(CPNS_NipBaru_TF.getText());
        cpns.setBerijazah(CPNS_Berijazah_TF.getText());
        cpns.setKode_operator(TP_Kode_Label.getText().toUpperCase());
        cpns.setTmt_cpns(sdf.format(CPNS_tmt_cpns.getDate()));

        try {
            Controller.ControlData.getKoneksi().updateCPNS(cpns);
            Controller.ControlData.getKoneksi().updatePNS("CPNS", CPNS_NipBaru_TF.getText(), CPNS_NoSurat_TF.getText());
            JOptionPane.showMessageDialog(rootPane, "Data SK CPNS Berhasil Diupdate");
            isiCPNS(cpns.getNip_baru());
        } catch (Exception ex) {
            Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_CPNS_update_buttonActionPerformed

    private void PT_update_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_PT_update_buttonActionPerformed
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

        SK_PangkatTerakhir pt = new SK_PangkatTerakhir();
        pt.setId_SuratPangkatTerakhir(PT_NoSurat_TF.getText());
        pt.setNama_pemilik(PT_Nama_TF.getText());
        pt.setTanggal_lahir(sdf.format(PT_TglLhr_Date.getDate()));
        pt.setNip_lama(PT_NipLama_TF.getText());
        pt.setNip_baru(PT_NipBaru_TF.getText());
        pt.setPendidikan(PT_Pend_TF.getText());
        pt.setPangkat_baru((String) PT_PngktBr_TF.getSelectedItem());
        pt.setGolongan_baru(PT_GolBr_TF.getText());
        pt.setTmt_baru(sdf.format(PT_TmtBr_Date.getDate()));
        pt.setMasa_kerja_golongan_tahun(PT_MsKerjaGolThn_TF.getText());
        pt.setGaji_pokok(PT_GajiPokok_TF.getText());
        pt.setMasa_kerja_golongan_bulan(PT_MsKerjaGolBln_TF.getText());
        pt.setKode_operator(TP_Kode_Label.getText().toUpperCase());
        pt.setProfesi(PT_Profesi_TF.getText());
        pt.setSekolah(PT_Sekolah_TF.getText());
        pt.setTempat_lahir(PT_TmpLhr_TF.getText());
        try {
            Controller.ControlData.getKoneksi().updateSK_PangkatTerakhir(pt);
            Controller.ControlData.getKoneksi().updatePNS("PANGKATTERAKHIR", CPNS_NipBaru_TF.getText(), PT_NoSurat_TF.getText());
            JOptionPane.showMessageDialog(rootPane, "Data SK PANGKAT TERAKHIR Berhasil Diupdate");
            isiSK_PangkatTerakhir(pt.getNip_baru());
        } catch (Exception ex) {
            Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_PT_update_buttonActionPerformed

    private void SPTKG_update_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_SPTKG_update_buttonActionPerformed
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

        SPTKG_Terakhir sptkg = new SPTKG_Terakhir();
        sptkg.setId_SuratSPTKGTerakhir(SPTKG_NoSurat_TF.getText());
        sptkg.setTempat_surat(SPTKG_TmpSurat_TF.getText());
        sptkg.setTanggal_surat(sdf.format(SPTKG_TglSurat_TF.getDate()));
        sptkg.setNama_pemilik(SPTKG_Nama_TF.getText());
        sptkg.setNip_baru(SPTKG_NipBaru_TF.getText());
        sptkg.setPangkat_baru((String) SPTKG_PangkatBr_TF.getSelectedItem());
        sptkg.setGolongan_ruang_baru(SPTKG_GolBr_TF.getText());
        sptkg.setSekolah(SPTKG_Sekolah_TF.getText());
        sptkg.setGajipokok_lama(SPTKG_GajiLama_TF.getText());
        sptkg.setGajipokok_baru(SPTKG_GajiBaru_TF.getText());
        sptkg.setTmt_baru(sdf.format(SPTKG_TmtBr_TF.getDate()));
        sptkg.setNip_lama(SPTKG_NipLama_TF.getText());
        sptkg.setKode_operator(TP_Kode_Label.getText().toUpperCase());
        try {
            Controller.ControlData.getKoneksi().updateSPTKG_Terakhir(sptkg);
            Controller.ControlData.getKoneksi().updatePNS("SPTKG",CPNS_NipBaru_TF.getText(),SPTKG_NoSurat_TF.getText());
            JOptionPane.showMessageDialog(rootPane, "Data SPTKG TERAKHIR Berhasil Diupdate");
            isiSPTKG_Terakhir(sptkg.getNip_baru());
        } catch (Exception ex) {
            Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_SPTKG_update_buttonActionPerformed

    private void Karpeg_simpan_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_Karpeg_simpan_buttonActionPerformed
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

        SK_Karpeg karpeg = new SK_Karpeg();
        karpeg.setId_SuratKarpeg(Karpeg_NoSurat_TF.getText());
        karpeg.setNip_lama(Karpeg_NipLama_TF.getText());
        karpeg.setNip_baru(Karpeg_NipBaru_TF.getText());
        karpeg.setNama_pemilik(Karpeg_Nama_TF.getText());
        karpeg.setTanggal_lahir(sdf.format(Karpeg_TglLhr_Date.getDate()));
        karpeg.setTmt_cpns(sdf.format(Karpeg_TMT_Date.getDate()));
        karpeg.setKode_operator(TP_Kode_Label.getText().toUpperCase());
        try {
            Controller.ControlData.getKoneksi().updateSK_Karpeg(karpeg);
            Controller.ControlData.getKoneksi().updatePNS("KARPEG",CPNS_NipBaru_TF.getText(),Karpeg_NoSurat_TF.getText());
            JOptionPane.showMessageDialog(rootPane, "Data KARPEG Berhasil Diupdate");
            isiSK_Karpeg(karpeg.getNip_baru());
        } catch (Exception ex) {
            Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_Karpeg_simpan_buttonActionPerformed

    private void SN_simpan_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_SN_simpan_buttonActionPerformed
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        S_Nikah nikah = new S_Nikah();
        nikah.setId_SuratNikah(SN_NoSurat_TF.getText());
        nikah.setTanggal_nikah(sdf.format(SN_TglNikah_Date.getDate()));
        nikah.setNama_suami(SN_NamaSuami_TF.getText());
        nikah.setNama_istri(SN_NamaIstri_TF.getText());
        nikah.setKode_operator(TP_Kode_Label.getText().toUpperCase());

        try {
            Controller.ControlData.getKoneksi().updateS_Nikah(nikah);
            JOptionPane.showMessageDialog(rootPane, "Data SURAT NIKAH Berhasil Diupdate");
            isiS_Nikah(NIP);
        } catch (Exception ex) {
            Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_SN_simpan_buttonActionPerformed

    private void AK_Batal_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AK_Batal_buttonActionPerformed
        KK_Internal.setVisible(false);
    }//GEN-LAST:event_AK_Batal_buttonActionPerformed

    private void KK_TambahAnggota_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_KK_TambahAnggota_buttonActionPerformed
        if (KK_Internal.isVisible() == true) {
            KK_Internal.setVisible(false);
        } else {
            KK_Internal.setVisible(true);
        }
    }//GEN-LAST:event_KK_TambahAnggota_buttonActionPerformed

    private void AK_Simpan_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AK_Simpan_buttonActionPerformed
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        String pekerjaan = (String) AK_Pekerjaan_Combo.getSelectedItem();

        ak = new AnggotaKeluarga();
        ak.setNik(AK_NIK_TF.getText());
        ak.setNama_lengkap(AK_Nama_TF.getText());
        ak.setJenis_kelamin((String) AK_JK_Combo.getSelectedItem());
        ak.setTempat_lahir(AK_TempatLahir_TF.getText());
        ak.setTanggal_lahir(sdf.format(AK_TanggalLahir_Date.getDate()));
        ak.setAgama((String) AK_Agama_Combo.getSelectedItem());
        ak.setPendidikan((String) AK_Pendidikan_Combo.getSelectedItem());
        if (!pekerjaan.equals("Lainnya...")) {
            ak.setPekerjaan((String) AK_Pekerjaan_Combo.getSelectedItem());
        } else {
            ak.setPekerjaan(AK_Pekerjaan_TF.getText());
        }
        ak.setStatus_perkawinan((String) AK_StatusKawin_Combo.getSelectedItem());
        ak.setStatus_hub_keluarga((String) AK_HubKeluarga_Combo.getSelectedItem());
        ak.setKewarganegaraan((String) AK_Kewarganegaraan_Combo.getSelectedItem());
        ak.setNo_paspor(AK_NoPaspor_TF.getText());
        ak.setNo_kitas_kitab(AK_NoKitasKitap_TF.getText());
        ak.setNama_ayah(AK_NamaAyah_TF.getText());
        ak.setNama_ibu(AK_NamaIbu_TF.getText());
        KK kartu = new KK();
        kartu.setId_Suratkk(idSuratkk);
        ak.setId_suratkk(kartu);

        try {
            Controller.ControlData.getKoneksi().updateAnggotaKeluarga(ak);
            JOptionPane.showMessageDialog(rootPane, "Berhasil DiUpdate");
            updateTerusTabelnyaKK(idSuratkk);

            KK_Internal.setVisible(false);
        } catch (Exception ex) {
            Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }

    }//GEN-LAST:event_AK_Simpan_buttonActionPerformed

    private void KK_SimpanKK_buttonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_KK_SimpanKK_buttonActionPerformed
        KK k = new KK();
        k.setId_Suratkk(KK_NoKK_TF.getText());
        k.setNama_kk(KK_NamaKK_TF.getText());
        k.setAlamat(KK_Alamat_TF.getText());
        k.setRT(KK_RT_TF.getText());
        k.setRW(KK_RW_TF.getText());
        k.setKelurahan_Desa(KK_KelDesa_TF.getText());
        k.setKecamatan(KK_Kec_TF.getText());
        k.setKabupaten_Kota(KK_KabKota_TF.getText());
        k.setKode_pos(KK_KodePos_TF.getText());
        k.setProvinsi(KK_Provinsi_TF.getText());
        k.setKode_operator(TP_Kode_Label.getText().toUpperCase());

        try {
            Controller.ControlData.getKoneksi().updateKK(k);
            idSuratkk = k.getId_Suratkk();
            JOptionPane.showMessageDialog(rootPane, "Data KARTU KELUARGA Berhasil diupdate");
            isiKK(NIP);
            KK_TambahAnggota_button.setEnabled(true);
        } catch (Exception ex) {
            Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_KK_SimpanKK_buttonActionPerformed

    private void AK_Pekerjaan_ComboActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AK_Pekerjaan_ComboActionPerformed
        String jawab = (String) AK_Pekerjaan_Combo.getSelectedItem();
        if (jawab.equals("Lainnya...")) {
            AK_Pekerjaan_TF.setEditable(true);
        } else {
            AK_Pekerjaan_TF.setText("-");
            AK_Pekerjaan_TF.setEditable(false);
        }
    }//GEN-LAST:event_AK_Pekerjaan_ComboActionPerformed

    private void KK_TabelAnggotaKel_TablelMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_KK_TabelAnggotaKel_TablelMouseClicked
        int row = KK_TabelAnggotaKel_Tablel.getSelectedRow();
        AK_Nama_TF.setText(ambilIsi(row, 1));
        AK_NIK_TF.setText(ambilIsi(row, 2));
        AK_JK_Combo.setSelectedItem(ambilIsi(row, 3));
        AK_TempatLahir_TF.setText(ambilIsi(row, 4));
        try {
            AK_TanggalLahir_Date.setDate(tukangSplit(ambilIsi(row, 5)));
        } catch (ParseException ex) {
            Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }
        AK_Agama_Combo.setSelectedItem(ambilIsi(row, 6));
        AK_Pendidikan_Combo.setSelectedItem(ambilIsi(row, 7));
        AK_Pekerjaan_Combo.setSelectedItem(ambilIsi(row, 8));
        AK_Pekerjaan_TF.setText(ambilIsi(row, 8));
        AK_StatusKawin_Combo.setSelectedItem(ambilIsi(row, 9));
        AK_HubKeluarga_Combo.setSelectedItem(ambilIsi(row, 10));
        AK_Kewarganegaraan_Combo.setSelectedItem(ambilIsi(row, 11));
        AK_NoPaspor_TF.setText(ambilIsi(row, 12));
        AK_NoKitasKitap_TF.setText(ambilIsi(row, 13));
        AK_NamaAyah_TF.setText(ambilIsi(row, 14));
        AK_NamaIbu_TF.setText(ambilIsi(row, 15));

        KK_Internal.setVisible(true);
        // TODO add your handling code here:
    }//GEN-LAST:event_KK_TabelAnggotaKel_TablelMouseClicked

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        FrameOperator fp = new FrameOperator();
        this.dispose();
        fp.setVisible(true);
        fp.dataOperator(TP_Nama_Label.getText(), TP_Kode_Label.getText());
        // TODO add your handling code here:
    }//GEN-LAST:event_jButton1ActionPerformed

    private void PT_PngktBr_TFActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_PT_PngktBr_TFActionPerformed
        String pangkat = (String) PT_PngktBr_TF.getSelectedItem();
        if (pangkat.matches("Pangkat Pengatur Muda")) {
            PT_GolBr_TF.setText("II/a");
        }
        if (pangkat.matches("Pangkat Pengatur Muda Tingkat 1")) {
            PT_GolBr_TF.setText("II/b");
        }
        if (pangkat.matches("Pangkat Pengatur")) {
            PT_GolBr_TF.setText("II/c");
        }
        if (pangkat.matches("Pangkat Pengatur Tingkat 1")) {
            PT_GolBr_TF.setText("II/d");
        }
        if (pangkat.matches("Pangkat Penata Muda")) {
            PT_GolBr_TF.setText("III/a");
        }
        if (pangkat.matches("Pangkat Penata Muda Tingkat 1")) {
            PT_GolBr_TF.setText("III/b");
        }
        if (pangkat.matches("Pangkat Penata")) {
            PT_GolBr_TF.setText("III/c");
        }
        if (pangkat.matches("Pangkat Penata Tingkat 1")) {
            PT_GolBr_TF.setText("III/d");
        }
        if (pangkat.matches("Pangkat Pembina")) {
            PT_GolBr_TF.setText("IV/a");
        }
        if (pangkat.matches("Pangkat Pembina Tingkat 1")) {
            PT_GolBr_TF.setText("IV/b");
        }
        if (pangkat.matches("Pangkat Pembina Utama Muda")) {
            PT_GolBr_TF.setText("IV/c");
        }
        if (pangkat.matches("Pangkat Pembina Utama Madya")) {
            PT_GolBr_TF.setText("IV/d");
        }
        if (pangkat.matches("Pangkat Pembina Utama")) {
            PT_GolBr_TF.setText("IV/e");
        }
        SPTKG_PangkatBr_TF.setSelectedItem(pangkat);
        SPTKG_GolBr_TF.setText(PT_GolBr_TF.getText());
        // TODO add your handling code here:
}//GEN-LAST:event_PT_PngktBr_TFActionPerformed

    private void SPTKG_PangkatBr_TFActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_SPTKG_PangkatBr_TFActionPerformed
        String pangkat = (String) SPTKG_PangkatBr_TF.getSelectedItem();
        if (pangkat.matches("Pangkat Pengatur Muda")) {
            SPTKG_GolBr_TF.setText("II/a");
        }
        if (pangkat.matches("Pangkat Pengatur Muda Tingkat 1")) {
            SPTKG_GolBr_TF.setText("II/b");
        }
        if (pangkat.matches("Pangkat Pengatur")) {
            SPTKG_GolBr_TF.setText("II/c");
        }
        if (pangkat.matches("Pangkat Pengatur Tingkat 1")) {
            SPTKG_GolBr_TF.setText("II/d");
        }
        if (pangkat.matches("Pangkat Penata Muda")) {
            SPTKG_GolBr_TF.setText("III/a");
        }
        if (pangkat.matches("Pangkat Penata Muda Tingkat 1")) {
            SPTKG_GolBr_TF.setText("III/b");
        }
        if (pangkat.matches("Pangkat Penata")) {
            SPTKG_GolBr_TF.setText("III/c");
        }
        if (pangkat.matches("Pangkat Penata Tingkat 1")) {
            SPTKG_GolBr_TF.setText("III/d");
        }
        if (pangkat.matches("Pangkat Pembina")) {
            SPTKG_GolBr_TF.setText("IV/a");
        }
        if (pangkat.matches("Pangkat Pembina Tingkat 1")) {
            SPTKG_GolBr_TF.setText("IV/b");
        }
        if (pangkat.matches("Pangkat Pembina Utama Muda")) {
            SPTKG_GolBr_TF.setText("IV/c");
        }
        if (pangkat.matches("Pangkat Pembina Utama Madya")) {
            SPTKG_GolBr_TF.setText("IV/d");
        }
        if (pangkat.matches("Pangkat Pembina Utama")) {
            SPTKG_GolBr_TF.setText("IV/e");
        }
    }//GEN-LAST:event_SPTKG_PangkatBr_TFActionPerformed

    private void SPTKG_GolBr_TFActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_SPTKG_GolBr_TFActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_SPTKG_GolBr_TFActionPerformed

    private void tmt_bkrja_simpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_tmt_bkrja_simpanActionPerformed
        try {
            Instansi instansi = new Instansi();
            instansi.setIdInstansi(tmt_bkrja_no_instansi.getText());
            instansi.setNm_kepala(tmt_bkrja_nama_kepala.getText());
            instansi.setNip_kepala(tmt_bkrja_nip_kepala.getText());
            instansi.setNmInstansi(tmt_bkrja_nm_instansi.getText());
            instansi.setPangkatGolkepala(tmt_bekerja_golongan.getText());
            PNS pns = new PNS();
            pns.setNama_pns(tmt_bkrja_nama_peg.getText());
            pns.setNip_baru(tmt_bkrja_nip_peg.getText());
            instansi.setPns(pns);
            ControlData.getKoneksi().updateTempatInstansi(instansi);
            JOptionPane.showMessageDialog(rootPane, "Data tempat bekerja Berhasil diupdate");
        } catch (Exception ex) {
            Logger.getLogger(TambahPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }
}//GEN-LAST:event_tmt_bkrja_simpanActionPerformed
    private String ambilIsi(int baris, int kolom) {
        return KK_TabelAnggotaKel_Tablel.getValueAt(baris, kolom).toString();
    }

    private int cekAngka(String isian) {
        if (!isian.matches("[0-9]*")) {
            JOptionPane.showMessageDialog(rootPane, "Masukkan harus angka..!!");
            return 0;
        }
        return 1;
    }

    private void updateTerusTabelnyaKK(String idSuratKK) {
        try {
            List<AnggotaKeluarga> listAk = Controller.ControlData.getKoneksi().SearchAllAnggota(idSuratKK);
            TampilAnggotaKeluarga model = new TampilAnggotaKeluarga(listAk);
            KK_TabelAnggotaKel_Tablel.setModel(model);
        } catch (Exception ex) {
            Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    public void isiCPNS(String nipBaru) throws Exception {
        SK_CPNS cpns = ControlData.getKoneksi().tampilSK_CPNS(nipBaru);
        if (cpns == null) {
            isiCPNSKosong(nipBaru);
        } else {
            CPNS_NoSurat_TF.setText(cpns.getId_SuratCPNS());
            CPNS_TmpBuatSurat_TF.setText(cpns.getTempat_surat());
            CPNS_TglSurat_Date.setDate(tukangSplit(cpns.getTanggal_surat()));
            CPNS_nama_TF.setText(cpns.getNama_pemilik());
            CPNS_TmpLhr_TF.setText(cpns.getTempat_lahir());
            CPNS_TglLhr_Date.setDate(tukangSplit(cpns.getTanggal_lahir()));
            CPNS_Profesi_TF.setText(cpns.getProfesi());
            CPNS_Sekolah_TF.setText(cpns.getSekolah());
            CPNS_MasaKerjaTahun_TF.setText(cpns.getMasa_kerja_tahun());
            CPNS_MasaKerjaBulan_TF.setText(cpns.getMasa_kerja_bulan());
            CPNS_Golongan_TF.setText(cpns.getGolongan());
            CPNS_NipLama_TF.setText(cpns.getNip_lama());
            CPNS_NipBaru_TF.setText(cpns.getNip_baru());
            CPNS_Berijazah_TF.setText(cpns.getBerijazah());
            CPNS_tanggalEdit.setText(tukangSplit2(cpns.getTanggal_penyimpanan_surat()).toString());
            CPNS_kode_ope.setText(cpns.getKode_operator());
            CPNS_tmt_cpns.setDate(tukangSplit(cpns.getTmt_cpns()));

        }
    }

    public void isiSK_PangkatTerakhir(String nipBaru) throws Exception {
        SK_PangkatTerakhir skpt = Controller.ControlData.getKoneksi().tampilSK_PangkatTerakhir(nipBaru);
        if (skpt == null) {
            isiSK_PangkatTerakhirKosong(nipBaru);
        } else {
            PT_NoSurat_TF.setText(skpt.getId_SuratPangkatTerakhir());
            PT_Nama_TF.setText(skpt.getNama_pemilik());
            PT_TmpLhr_TF.setText(skpt.getTempat_lahir());
            PT_TglLhr_Date.setDate(tukangSplit(skpt.getTanggal_lahir()));
            PT_NipLama_TF.setText(skpt.getNip_lama());
            PT_NipBaru_TF.setText(skpt.getNip_baru());
            PT_Pend_TF.setText(skpt.getPendidikan());
            PT_Profesi_TF.setText(skpt.getProfesi());
            PT_Sekolah_TF.setText(skpt.getSekolah());
            PT_PngktBr_TF.setSelectedItem(skpt.getPangkat_baru());
            PT_GolBr_TF.setText(skpt.getGolongan_baru());
            PT_TmtBr_Date.setDate(tukangSplit(skpt.getTmt_baru()));
            PT_MsKerjaGolBln_TF.setText(skpt.getMasa_kerja_golongan_bulan());
            PT_GajiPokok_TF.setText(skpt.getGaji_pokok());
            PT_tanggalEdit.setText(tukangSplit2(skpt.getTanggal_penyimpanan_surat()).toString());
            PT_kode_ope.setText(skpt.getKode_operator());
        }
    }

    public void isiSPTKG_Terakhir(String nipBaru) throws Exception {
        SPTKG_Terakhir sptkg = Controller.ControlData.getKoneksi().tampilSPTKG_Terakhir(nipBaru);
        if (sptkg == null) {
            isiSPTKG_TerakhirKosong(nipBaru);
        } else {
            SPTKG_NoSurat_TF.setText(sptkg.getId_SuratSPTKGTerakhir());
            SPTKG_TmpSurat_TF.setText(sptkg.getTempat_surat());
            SPTKG_TglSurat_TF.setDate(tukangSplit(sptkg.getTanggal_surat()));
            SPTKG_Nama_TF.setText(sptkg.getNama_pemilik());
            SPTKG_NipLama_TF.setText(sptkg.getNip_lama());
            SPTKG_NipBaru_TF.setText(sptkg.getNip_baru());
            SPTKG_PangkatBr_TF.setSelectedItem(sptkg.getPangkat_baru());
            SPTKG_GolBr_TF.setText(sptkg.getGolongan_ruang_baru());
            SPTKG_Sekolah_TF.setText(sptkg.getSekolah());
            SPTKG_GajiLama_TF.setText(sptkg.getGajipokok_lama());
            SPTKG_GajiBaru_TF.setText(sptkg.getGajipokok_baru());
            SPTKG_TmtBr_TF.setDate(tukangSplit(sptkg.getTmt_baru()));
            SPTKG_tanggalEdit.setText(tukangSplit2(sptkg.getTanggal_penyimpanan_surat()));
            SPTKG_kode_ope.setText(sptkg.getKode_operator());
        }
    }

    public void isiSK_Karpeg(String nipBaru) throws Exception {
        SK_Karpeg karpeg = Controller.ControlData.getKoneksi().tampilSK_Karpeg(nipBaru);
        if (karpeg == null) {
            isiSK_KarpegKosong(nipBaru);
        } else {
            Karpeg_NoSurat_TF.setText(karpeg.getId_SuratKarpeg());
            Karpeg_Nama_TF.setText(karpeg.getNama_pemilik());
            Karpeg_NipLama_TF.setText(karpeg.getNip_lama());
            Karpeg_NipBaru_TF.setText(karpeg.getNip_baru());
            Karpeg_TglLhr_Date.setDate(tukangSplit(karpeg.getTanggal_lahir()));
            Karpeg_TMT_Date.setDate(tukangSplit(karpeg.getTmt_cpns()));
            Karpeg_tanggalEdit.setText(tukangSplit2(karpeg.getTanggal_penyimpanan_surat()));
            Karpeg_kode_ope.setText(karpeg.getKode_operator());
        }
    }

    public void isiS_Nikah(String nipBaru) throws Exception {
        S_Nikah sn = Controller.ControlData.getKoneksi().tampilS_Nikah(nipBaru);
        if (sn == null) {
            isiS_NikahKosong(nipBaru);
        } else {
            SN_NoSurat_TF.setText(sn.getId_SuratNikah());
            SN_TglNikah_Date.setDate(tukangSplit(sn.getTanggal_nikah()));
            SN_NamaSuami_TF.setText(sn.getNama_suami());
            SN_NamaIstri_TF.setText(sn.getNama_istri());
            SN_tanggalEdit.setText(tukangSplit2(sn.getTanggal_penyimpanan_surat()));
            SN_kode_ope.setText(sn.getKode_operator());
        }
    }

    public void isiKK(String nipBaru) throws Exception {
        KK kk = Controller.ControlData.getKoneksi().tampilKK(nipBaru);
        if (kk == null) {
            isiKK_kosong(nipBaru, KK_NoKK_TF.getText());
        } else {
            KK_NoKK_TF.setText(kk.getId_Suratkk());
            KK_NamaKK_TF.setText(kk.getNama_kk());
            KK_Alamat_TF.setText(kk.getAlamat());
            KK_RT_TF.setText(kk.getRT());
            KK_RW_TF.setText(kk.getRW());
            KK_KelDesa_TF.setText(kk.getKelurahan_Desa());
            KK_Kec_TF.setText(kk.getKecamatan());
            KK_KabKota_TF.setText(kk.getKabupaten_Kota());
            KK_KodePos_TF.setText(kk.getKode_pos());
            KK_Provinsi_TF.setText(kk.getProvinsi());
            KK_tanggalEdit.setText(tukangSplit2(kk.getTanggal_penyimpanan_surat()));
            KK_kode_ope.setText(kk.getKode_operator());
            updateTerusTabelnyaKK(kk.getId_Suratkk());
            idSuratkk = kk.getId_Suratkk();
        }

    }

    public void isiCPNSKosong(String nipBaru) throws Exception {
        CPNS_NoSurat_TF.setText("-");
        CPNS_TmpBuatSurat_TF.setText("-");
        CPNS_TglSurat_Date.setDate(null);
        CPNS_nama_TF.setText("-");
        CPNS_TmpLhr_TF.setText("-");
        CPNS_TglLhr_Date.setDate(null);
        CPNS_Profesi_TF.setText("-");
        CPNS_Sekolah_TF.setText("-");
        CPNS_MasaKerjaTahun_TF.setText("-");
        CPNS_MasaKerjaBulan_TF.setText("-");
        CPNS_Golongan_TF.setText("-");
        CPNS_NipLama_TF.setText("-");
        CPNS_NipBaru_TF.setText("-");
        CPNS_Berijazah_TF.setText("-");
//        CPNS_tanggalEdit.setText("-");
//        CPNS_kode_ope.setText("-");
    }

    public void isiSK_PangkatTerakhirKosong(String nipBaru) throws Exception {
        PT_NoSurat_TF.setText("-");
        PT_Nama_TF.setText("-");
        PT_TmpLhr_TF.setText("-");
        PT_TglLhr_Date.setDate(null);
        PT_NipLama_TF.setText("-");
        PT_NipBaru_TF.setText("-");
        PT_Pend_TF.setText("-");
        PT_Profesi_TF.setText("-");
        PT_Sekolah_TF.setText("-");
        PT_PngktBr_TF.setSelectedItem("-");
        PT_GolBr_TF.setText("-");
        PT_TmtBr_Date.setDate(null);
        PT_MsKerjaGolThn_TF.setText("-");
        PT_MsKerjaGolBln_TF.setText("-");
        PT_GajiPokok_TF.setText("-");
//        PT_tanggalEdit.setText(tukangSplit2(skpt.getTanggal_penyimpanan_surat()).toString());
//        PT_kode_ope.setText(skpt.getKode_operator());
    }

    public void isiSPTKG_TerakhirKosong(String nipBaru) throws Exception {
        SPTKG_NoSurat_TF.setText("-");
        SPTKG_TmpSurat_TF.setText("-");
        SPTKG_TglSurat_TF.setDate(null);
        SPTKG_Nama_TF.setText("-");
        SPTKG_NipLama_TF.setText("-");
        SPTKG_NipBaru_TF.setText("-");
        SPTKG_PangkatBr_TF.setSelectedItem("-");
        SPTKG_GolBr_TF.setText("-");
        SPTKG_Sekolah_TF.setText("-");
        SPTKG_GajiLama_TF.setText("-");
        SPTKG_GajiBaru_TF.setText("-");
        SPTKG_TmtBr_TF.setDate(null);
//        SPTKG_tanggalEdit.setText(tukangSplit2(sptkg.getTanggal_penyimpanan_surat()));
//        SPTKG_kode_ope.setText(sptkg.getKode_operator());
    }

    public void isiSK_KarpegKosong(String nipBaru) throws Exception {
        Karpeg_NoSurat_TF.setText("-");
        Karpeg_Nama_TF.setText("-");
        Karpeg_NipLama_TF.setText("-");
        Karpeg_NipBaru_TF.setText("-");
        Karpeg_TglLhr_Date.setDate(null);
        Karpeg_TMT_Date.setDate(null);
//        Karpeg_tanggalEdit.setText(tukangSplit2(karpeg.getTanggal_penyimpanan_surat()));
//        Karpeg_kode_ope.setText(karpeg.getKode_operator());
    }

    public void isiS_NikahKosong(String nipBaru) throws Exception {
        SN_NoSurat_TF.setText("-");
        SN_TglNikah_Date.setDate(null);
        SN_NamaSuami_TF.setText("-");
        SN_NamaIstri_TF.setText("-");
//        SN_tanggalEdit.setText(tukangSplit2(sn.getTanggal_penyimpanan_surat()));
//        SN_kode_ope.setText(sn.getKode_operator());
    }

    public void isiKK_kosong(String nipBaru, String idSuratkk) throws Exception {
        KK_NoKK_TF.setText("-");
        KK_NamaKK_TF.setText("-");
        KK_Alamat_TF.setText("");
        KK_RT_TF.setText("-");
        KK_RW_TF.setText("-");
        KK_KelDesa_TF.setText("-");
        KK_Kec_TF.setText("-");
        KK_KabKota_TF.setText("-");
        KK_KodePos_TF.setText("-");
        KK_Provinsi_TF.setText("-");
        KK_tanggalEdit.setText(null);
        KK_kode_ope.setText("-");
//        updateTerusTabelnyaKK(kk.getId_Suratkk());
//        idSuratkk = kk.getId_Suratkk();
    }

    private void kosongDataKK() {
        int row = KK_TabelAnggotaKel_Tablel.getSelectedRow();
        AK_Nama_TF.setText("-");
        AK_NIK_TF.setText("-");
        AK_JK_Combo.setSelectedItem("");
        AK_TempatLahir_TF.setText("-");

        AK_TanggalLahir_Date.setDate(null);
        AK_Agama_Combo.setSelectedItem("");
        AK_Pendidikan_Combo.setSelectedItem("");
        AK_Pekerjaan_Combo.setSelectedItem("");
        AK_Pekerjaan_TF.setText("-");
        AK_StatusKawin_Combo.setSelectedItem("");
        AK_HubKeluarga_Combo.setSelectedItem("");
        AK_Kewarganegaraan_Combo.setSelectedItem("");
        AK_NoPaspor_TF.setText("-");
        AK_NoKitasKitap_TF.setText("-");
        AK_NamaAyah_TF.setText("-");
        AK_NamaIbu_TF.setText("-");
    }

    public void dataOperatorEditPegawai(String nama, String id) {
        TP_Nama_Label.setText(nama);
        TP_Kode_Label.setText(id);
    }

    public Date tukangSplit(String tanggal) throws ParseException {
        String[] split = tanggal.split("-");
        String formatBener = split[2] + "-" + split[1] + "-" + split[0];
        Date kirimFormat = new SimpleDateFormat("dd-MM-yyyy").parse(formatBener);
        return kirimFormat;
    }

    public String tukangSplit2(String tanggal) { //buat tanggal penyimpanan
        String[] split = tanggal.split("-");
        String formatBener = split[2] + "-" + split[1] + "-" + split[0];
        return formatBener;
    }

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                try {
                    new EditPegawai().setVisible(true);
                } catch (Exception ex) {
                    Logger.getLogger(EditPegawai.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        });
    }
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JComboBox AK_Agama_Combo;
    private javax.swing.JButton AK_Batal_button;
    private javax.swing.JComboBox AK_HubKeluarga_Combo;
    private javax.swing.JComboBox AK_JK_Combo;
    private javax.swing.JComboBox AK_Kewarganegaraan_Combo;
    private javax.swing.JTextField AK_NIK_TF;
    private javax.swing.JTextField AK_NamaAyah_TF;
    private javax.swing.JTextField AK_NamaIbu_TF;
    private javax.swing.JTextField AK_Nama_TF;
    private javax.swing.JTextField AK_NoKitasKitap_TF;
    private javax.swing.JTextField AK_NoPaspor_TF;
    private javax.swing.JComboBox AK_Pekerjaan_Combo;
    private javax.swing.JTextField AK_Pekerjaan_TF;
    private javax.swing.JComboBox AK_Pendidikan_Combo;
    private javax.swing.JButton AK_Simpan_button;
    private javax.swing.JComboBox AK_StatusKawin_Combo;
    private com.toedter.calendar.JDateChooser AK_TanggalLahir_Date;
    private javax.swing.JTextField AK_TempatLahir_TF;
    private javax.swing.JTextField CPNS_Berijazah_TF;
    private javax.swing.JTextField CPNS_Golongan_TF;
    private javax.swing.JTextField CPNS_MasaKerjaBulan_TF;
    private javax.swing.JTextField CPNS_MasaKerjaTahun_TF;
    private javax.swing.JTextField CPNS_NipBaru_TF;
    private javax.swing.JTextField CPNS_NipLama_TF;
    private javax.swing.JTextField CPNS_NoSurat_TF;
    private javax.swing.JTextField CPNS_Profesi_TF;
    private javax.swing.JTextField CPNS_Sekolah_TF;
    private com.toedter.calendar.JDateChooser CPNS_TglLhr_Date;
    private com.toedter.calendar.JDateChooser CPNS_TglSurat_Date;
    private javax.swing.JTextField CPNS_TmpBuatSurat_TF;
    private javax.swing.JTextField CPNS_TmpLhr_TF;
    private javax.swing.JLabel CPNS_kode_ope;
    private javax.swing.JTextField CPNS_nama_TF;
    private javax.swing.JLabel CPNS_tanggalEdit;
    private com.toedter.calendar.JDateChooser CPNS_tmt_cpns;
    private javax.swing.JButton CPNS_update_button;
    private javax.swing.JPanel KK;
    private javax.swing.JTextField KK_Alamat_TF;
    private javax.swing.JInternalFrame KK_Internal;
    private javax.swing.JTextField KK_KabKota_TF;
    private javax.swing.JTextField KK_Kec_TF;
    private javax.swing.JTextField KK_KelDesa_TF;
    private javax.swing.JTextField KK_KodePos_TF;
    private javax.swing.JTextField KK_NamaKK_TF;
    private javax.swing.JTextField KK_NoKK_TF;
    private javax.swing.JTextField KK_Provinsi_TF;
    private javax.swing.JTextField KK_RT_TF;
    private javax.swing.JTextField KK_RW_TF;
    private javax.swing.JButton KK_SimpanKK_button;
    private javax.swing.JTable KK_TabelAnggotaKel_Tablel;
    private javax.swing.JButton KK_TambahAnggota_button;
    private javax.swing.JLabel KK_kode_ope;
    private javax.swing.JLabel KK_tanggalEdit;
    private javax.swing.JTextField Karpeg_Nama_TF;
    private javax.swing.JTextField Karpeg_NipBaru_TF;
    private javax.swing.JTextField Karpeg_NipLama_TF;
    private javax.swing.JTextField Karpeg_NoSurat_TF;
    private com.toedter.calendar.JDateChooser Karpeg_TMT_Date;
    private com.toedter.calendar.JDateChooser Karpeg_TglLhr_Date;
    private javax.swing.JLabel Karpeg_kode_ope;
    private javax.swing.JButton Karpeg_simpan_button;
    private javax.swing.JLabel Karpeg_tanggalEdit;
    private javax.swing.JTextField PT_GajiPokok_TF;
    private javax.swing.JTextField PT_GolBr_TF;
    private javax.swing.JTextField PT_MsKerjaGolBln_TF;
    private javax.swing.JTextField PT_MsKerjaGolThn_TF;
    private javax.swing.JTextField PT_Nama_TF;
    private javax.swing.JTextField PT_NipBaru_TF;
    private javax.swing.JTextField PT_NipLama_TF;
    private javax.swing.JTextField PT_NoSurat_TF;
    private javax.swing.JTextField PT_Pend_TF;
    private javax.swing.JComboBox PT_PngktBr_TF;
    private javax.swing.JTextField PT_Profesi_TF;
    private javax.swing.JTextField PT_Sekolah_TF;
    private com.toedter.calendar.JDateChooser PT_TglLhr_Date;
    private javax.swing.JTextField PT_TmpLhr_TF;
    private com.toedter.calendar.JDateChooser PT_TmtBr_Date;
    private javax.swing.JLabel PT_kode_ope;
    private javax.swing.JLabel PT_tanggalEdit;
    private javax.swing.JButton PT_update_button;
    private javax.swing.JPanel SK_CPNS;
    private javax.swing.JPanel SK_Karpeg;
    private javax.swing.JPanel SK_PangkatTerakhir;
    private javax.swing.JTextField SN_NamaIstri_TF;
    private javax.swing.JTextField SN_NamaSuami_TF;
    private javax.swing.JTextField SN_NoSurat_TF;
    private com.toedter.calendar.JDateChooser SN_TglNikah_Date;
    private javax.swing.JLabel SN_kode_ope;
    private javax.swing.JButton SN_simpan_button;
    private javax.swing.JLabel SN_tanggalEdit;
    private javax.swing.JTextField SPTKG_GajiBaru_TF;
    private javax.swing.JTextField SPTKG_GajiLama_TF;
    private javax.swing.JTextField SPTKG_GolBr_TF;
    private javax.swing.JTextField SPTKG_Nama_TF;
    private javax.swing.JTextField SPTKG_NipBaru_TF;
    private javax.swing.JTextField SPTKG_NipLama_TF;
    private javax.swing.JTextField SPTKG_NoSurat_TF;
    private javax.swing.JComboBox SPTKG_PangkatBr_TF;
    private javax.swing.JTextField SPTKG_Sekolah_TF;
    private javax.swing.JPanel SPTKG_Terakhir;
    private com.toedter.calendar.JDateChooser SPTKG_TglSurat_TF;
    private javax.swing.JTextField SPTKG_TmpSurat_TF;
    private com.toedter.calendar.JDateChooser SPTKG_TmtBr_TF;
    private javax.swing.JLabel SPTKG_kode_ope;
    private javax.swing.JLabel SPTKG_tanggalEdit;
    private javax.swing.JButton SPTKG_update_button;
    private javax.swing.JPanel Surat_Nikah;
    private javax.swing.JLabel TP_Kode_Label;
    private javax.swing.JLabel TP_Nama_Label;
    private javax.swing.JTabbedPane Tab_PNS;
    private javax.swing.JButton jButton1;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel100;
    private javax.swing.JLabel jLabel101;
    private javax.swing.JLabel jLabel102;
    private javax.swing.JLabel jLabel103;
    private javax.swing.JLabel jLabel104;
    private javax.swing.JLabel jLabel105;
    private javax.swing.JLabel jLabel106;
    private javax.swing.JLabel jLabel107;
    private javax.swing.JLabel jLabel108;
    private javax.swing.JLabel jLabel109;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel110;
    private javax.swing.JLabel jLabel111;
    private javax.swing.JLabel jLabel112;
    private javax.swing.JLabel jLabel113;
    private javax.swing.JLabel jLabel114;
    private javax.swing.JLabel jLabel115;
    private javax.swing.JLabel jLabel116;
    private javax.swing.JLabel jLabel117;
    private javax.swing.JLabel jLabel118;
    private javax.swing.JLabel jLabel119;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    private javax.swing.JLabel jLabel25;
    private javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel28;
    private javax.swing.JLabel jLabel29;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel30;
    private javax.swing.JLabel jLabel31;
    private javax.swing.JLabel jLabel32;
    private javax.swing.JLabel jLabel33;
    private javax.swing.JLabel jLabel34;
    private javax.swing.JLabel jLabel35;
    private javax.swing.JLabel jLabel36;
    private javax.swing.JLabel jLabel37;
    private javax.swing.JLabel jLabel38;
    private javax.swing.JLabel jLabel39;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel40;
    private javax.swing.JLabel jLabel41;
    private javax.swing.JLabel jLabel42;
    private javax.swing.JLabel jLabel43;
    private javax.swing.JLabel jLabel44;
    private javax.swing.JLabel jLabel45;
    private javax.swing.JLabel jLabel46;
    private javax.swing.JLabel jLabel47;
    private javax.swing.JLabel jLabel48;
    private javax.swing.JLabel jLabel49;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel50;
    private javax.swing.JLabel jLabel51;
    private javax.swing.JLabel jLabel52;
    private javax.swing.JLabel jLabel53;
    private javax.swing.JLabel jLabel54;
    private javax.swing.JLabel jLabel55;
    private javax.swing.JLabel jLabel56;
    private javax.swing.JLabel jLabel57;
    private javax.swing.JLabel jLabel58;
    private javax.swing.JLabel jLabel59;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel60;
    private javax.swing.JLabel jLabel61;
    private javax.swing.JLabel jLabel62;
    private javax.swing.JLabel jLabel63;
    private javax.swing.JLabel jLabel64;
    private javax.swing.JLabel jLabel65;
    private javax.swing.JLabel jLabel66;
    private javax.swing.JLabel jLabel67;
    private javax.swing.JLabel jLabel68;
    private javax.swing.JLabel jLabel69;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel70;
    private javax.swing.JLabel jLabel71;
    private javax.swing.JLabel jLabel72;
    private javax.swing.JLabel jLabel73;
    private javax.swing.JLabel jLabel75;
    private javax.swing.JLabel jLabel76;
    private javax.swing.JLabel jLabel77;
    private javax.swing.JLabel jLabel78;
    private javax.swing.JLabel jLabel79;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel80;
    private javax.swing.JLabel jLabel81;
    private javax.swing.JLabel jLabel82;
    private javax.swing.JLabel jLabel83;
    private javax.swing.JLabel jLabel84;
    private javax.swing.JLabel jLabel85;
    private javax.swing.JLabel jLabel86;
    private javax.swing.JLabel jLabel87;
    private javax.swing.JLabel jLabel88;
    private javax.swing.JLabel jLabel89;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JLabel jLabel90;
    private javax.swing.JLabel jLabel91;
    private javax.swing.JLabel jLabel92;
    private javax.swing.JLabel jLabel93;
    private javax.swing.JLabel jLabel94;
    private javax.swing.JLabel jLabel95;
    private javax.swing.JLabel jLabel96;
    private javax.swing.JLabel jLabel97;
    private javax.swing.JLabel jLabel98;
    private javax.swing.JLabel jLabel99;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel8;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JPanel tempat_bekerja;
    private javax.swing.JLabel time;
    private javax.swing.JTextField tmt_bekerja_golongan;
    private javax.swing.JTextField tmt_bkrja_nama_kepala;
    private javax.swing.JTextField tmt_bkrja_nama_peg;
    private javax.swing.JTextField tmt_bkrja_nip_kepala;
    private javax.swing.JTextField tmt_bkrja_nip_peg;
    private javax.swing.JTextField tmt_bkrja_nm_instansi;
    private javax.swing.JTextField tmt_bkrja_no_instansi;
    private javax.swing.JButton tmt_bkrja_simpan;
    // End of variables declaration//GEN-END:variables

    private void isiTempatInstansi(String nipBaru) throws Exception {
         Instansi instansi = ControlData.getKoneksi().tampil_tempat_instansi(nipBaru);
        if (instansi == null) {
            kosongTmpat(nipBaru);
        } else {
            tmt_bkrja_no_instansi.setText(instansi.getIdInstansi());
            tmt_bkrja_nm_instansi.setText(instansi.getNmInstansi());
            tmt_bkrja_nama_kepala.setText((instansi.getNm_kepala()));
            tmt_bekerja_golongan.setText(instansi.getPangkatGolkepala());
            tmt_bkrja_nip_kepala.setText(instansi.getNip_kepala());
            tmt_bkrja_nama_peg.setText((instansi.getPns().getNama_pns()));
            tmt_bkrja_nip_peg.setText(instansi.getPns().getNip_baru());
        }
    }

    private void kosongTmpat(String nipBaru) {
         tmt_bkrja_no_instansi.setText("");
            tmt_bkrja_nm_instansi.setText("");
            tmt_bkrja_nama_kepala.setText((""));
            tmt_bekerja_golongan.setText("");
            tmt_bkrja_nip_kepala.setText("");
            tmt_bkrja_nama_peg.setText("");
            tmt_bkrja_nip_peg.setText("");
    }
}
